3 Replies Latest reply on Nov 29, 2018 11:22 PM by Amit Dalmia

    Need help with running sums - Tableau newbie

    Amit Dalmia

      Hi everyone,

       

      I am looking to create a chart with the running sum on the Y-axis and Date on the X-axis. Here is the sample data for understanding of the problem -

       

         

      flagactivation_datecreated_date
      029-Nov-1826-Nov-18
      029-Nov-1826-Nov-18
      127-Nov-1826-Nov-18
      027-Nov-1826-Nov-18
      127-Nov-1826-Nov-18
      128-Nov-1826-Nov-18
      128-Nov-1826-Nov-18
      027-Nov-1826-Nov-18
      127-Nov-1826-Nov-18
      028-Nov-1827-Nov-18
      128-Nov-1827-Nov-18
      128-Nov-1827-Nov-18
      028-Nov-1827-Nov-18
      128-Nov-1827-Nov-18
      128-Nov-1827-Nov-18
      128-Nov-1828-Nov-18
      128-Nov-1828-Nov-18
      028-Nov-1828-Nov-18
      029-Nov-1828-Nov-18
      028-Nov-1828-Nov-18
      129-Nov-1828-Nov-18
      029-Nov-1828-Nov-18
      029-Nov-1828-Nov-18
      129-Nov-1828-Nov-18

       

      When one takes the sum of 'flag' values by activation_date, we get the table as  -

       

        

      Row LabelsSum of flag
      27-Nov-183
      28-Nov-188
      29-Nov-182
      Grand Total13

       

       

      BUT (there is always a but )...

       

      I want to create a chart with the corresponding table like below -

         

      activation_datesum of flag
      27-Nov-183
      28-Nov-1811(sum of 3 + 8)
      29-Nov-1813(sum of 11 + 2)

       

      I know how to do this in Excel but how do I do this in Tableau. I am assuming it is quite a basic ask and would really appreciate some help! The Tableau community seems buzzing with helpful replies and hence, I am quite optimistic to get help.