0 Replies Latest reply on Feb 20, 2012 5:19 PM by marvin.gouw

    Doing a self lookup into a Table and Graphing results

      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)

      Name
      track_idamtcreated_at
      Bobinstall
      Feb 1
      Bobpurchase$14Feb 4
      Bobpurchase$20Feb 14
      Bobpurchase$80Feb 25
      Sarahinstall
      Feb 3
      Sarahpurchase$1Feb 4
      Sarahpurchase$20Feb 10
      Sarahpurchase$15Feb 16
      Angelainstall
      Feb 2
      Angelapurchase$50Feb 20

       

      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:

      Purchase amounts5 days10 days15 days
      0X

      5
      X
      10

      X
      20


      where the X's are the points of the line graph I'm trying to visualize.

       

      Any way I can do this?

       

      Thanks!

      Marvin