15 Replies Latest reply: Mar 25, 2018 8:10 PM by Sunny Talwar RSS

    Accumulation in line graph not happening even after using rangesum(above)

    Supriya R

      Hi,

       

      i have created a line graph where it displays counts of open, which is delivered and opened on firstday for a particular batch hourly.

      Dimension:Hour(formatted_opened_date)

      Expression:COUNT(Distinct Aggr(IF(formatted_opened_date = Min(Total <batch_meta_data_id>formatted_opened_date),invitation_id),formatted_opened_date,invitation_id,batch_meta_data_id))

       

       

      Now i want to do a accumulation line chart, So i changed expression to :

      rangesum(above(COUNT(Distinct Aggr(IF(formatted_opened_date = Min(Total <batch_meta_data_id>formatted_opened_date),invitation_id),formatted_opened_date,invitation_id,batch_meta_data_id)), 0, Rowno()))

       

      But this is not at all giving accumulated records.

       

      Please help me on this!. I have attached a sample app.