Count every entry before date plus date itself?

[jisephcirspy]

I want to create a chart showing a timeline (dimension = date) and the y-axis should be the count method.

Here the entry 2020-05-05 should count 1, the entry 2020-06-08 should count 3, the entry 2020-06-16 should count 6.

How can I do this?

[MayilVahanan · Accepted solution]

Hi @jisephcirspy 

Try like this

Dim: Date

Exp: Rangesum(Above(Count(YourMethodFieldName),0, RowNo()))

[jisephcirspy]

you are a genius mayil ❤️

[jisephcirspy]

but the filter function isn't working properly now... it only show one entry when I filter every single date. Do you know how to fix that?