So I'm trying to do a lookup into our table per row and want to display the results in a graph. Here is an example:
Data(all in one table)
Now I want to get a graph of things like:
Customer Age vs. Average Spend
Customer Age vs. Number of Purchases
Customer Age vs. Avg numer of Purchases
where Customer Age is the age of each transaction relative to the install date.
So here's a sample graph of what I expect to see:
where the X's are the points of the line graph I'm trying to visualize.
Any way I can do this?
Retrieving data ...