cumulative count (special)

[ali_hijazi]

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

[ogautier62]

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