2 Replies Latest reply: Sep 23, 2015 5:38 PM by Jeff Kodish RSS

    Creating an accumulating count by date in a line chart?

    Jeff Kodish

      I have data from Salesforce, and want to show the growing monthly total for our contacts, i.e. count(name) for the x-axis value Date(MonthStart(CreatedDate)) plus all dates before it. I could only find answers pertaining to sums, but I'm not counting a numerical value. How can I do this?

       

      Ex.

      IDNameCreatedDate
      209570270Name11/5/15
      235920952Name2

      2/5/15

      252000980Name32/5/15
      345989453Name43/5/15
      340958092Name55/5/15
      235092435Name66/5/15

       

      Desired Line Chart

      1.PNG