hi to all ,
i have Projects table with start_date field for each project . for each project there are many Registrations in Registrations Table with start_date field for each Registration. i need to count the number of Registrations ( for each Project ) accordind to the interval days btween Project start_date and Registrations start_date .
for example:
interval of 1 day - project 10 have 100 Registrations , roject 20 have 150 Registrations .
interval of 2 day - project 10 have 60 Registrations , project 15 have 200 Registrations , roject 20 have 30 Registrations .
...
i tried using aggr in calculated dimension but there is a problem when compute the interval days ,
thanks.
