Hi Everyone,
I have a scenario where i have to show :
-Persons without registrations for less than 12 months
-Persons without registrations for more than 12 months
I am using below Calculated dimensions:
=if(
aggr(max(MonthEnd(Date(Date))),Person)<MonthEnd(AddMonths(aggr(max(TOTAL Date(Date)),Person),-12)),'Persons without registrations for more than 12 months',
if(aggr(max((Date(Date))),Person)>=MonthStart(AddMonths(aggr(max(TOTAL Date(Date)),Person),-11)),'Persons without registrations for less than 12 months',
'Without registrations'))
And below expression :
count(DISTINCT Person)
So when i select for example June 2019 i have to see at the dimension 'Persons without registrations for less than 12 months' , person who have registration between July 2018 and June 2019. But with my expressions i only have persons who have registration between January 2019 and June 2019.
Any idea how to handle that ?
Thank you in advance
