First, sorry for my bad english, hope you will be able to understand what I mean.
I have some data and especially some date. I would like to have as dimension the time, from the early date (day by day) and count item when the date is between the start date and the end date.
Something like :
count (Distinct If(item_date_start <= date_dimension <= item_date_end, 1, 0 )
Actually, my dimension is the item_date_start.
Solved! Go to Solution.
event- start_date - end_date
A - 01/205 - 03/2015
B - 02/2005 - 06/2015
C - 01/2015 - 08/2015
January : 2 events
February : 3 events
March : 3 events
April : 2 events ..
The easiest way i found was to take the start date as dimension .