cumulative count (special)

ali_hijazi — Thu, 24 May 2018 08:52:21 GMT

Hello

Got a bar chart

and I have the following expression : Count(distinct User)

in the Bar Chart I got a dimension which is Date

what I want to accomplish is the following:

ok in 1/25/2017 I got 1 User

in 1/26/2017 I should have 2 Users

in 1/30/2017 I should have 3 Users

in 2/9/2017 I should have 5 Users

in 2/10/2017 I should also have 5 users because jharb and adauphin appeared previously
.....

so on a specific date if a user appeared on previous dates then this user shouldn't be counted again

kindly advise on how to accomplish this

Note: if user selects 2/9/2017 the number 5 should be visible and not 2
the chart won't have the user as dimension ; only the date

Message was edited by: Ali Hijazi

Re: cumulative count (special)

ogautier62 — Thu, 24 May 2018 09:28:38 GMT

Hi,

add an expression X with :

if(Date= aggr(min(Date), User,1,0) that's count 1 time your user

and another expression Y which is Y + above(X)

regards