Cumulation covid-19 daily cases

[qliktick]

there are new cases of covid-19 reported by the ecdc Department. i Need to sum up the (new) daily cases to get the total number in a line-chart / table per day.

the "cumulate" box within the Chart is not working, all my effords with set-expressions didn't work. i thought i am an advanced user, but after Hours for such a Basic feature i am frustrated (table calc in Tableau ist easy)

please help and use my source..

[Frank_Hartmann · Accepted solution]

try  this expression:

Rangesum(above(sum (Cases),0,RowNo()))

[sergio0592 · Accepted solution]

Hi,

If you the cumulative daily cases, try with the Following formula as expression. It should works

rangesum(Above(Sum(Cases),0,RowNo()))