Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My requirement is to identify the cases of ECI that have repeated when compared with the previous month.
I have been able to use the following expression
=count( DISTINCT {<ECI=p({<Created_Month={'$(=MonthName(Max(CREATED_DATE)))'}>}ECI)> *<ECI=p({<Created_Month={'$(=MonthName(Max(CREATED_DATE),-1))'}>}ECI)> } ECI)
and it works fine. The issue is I am unable to filter it correctly.
For example:
I have another field in the same table but it is unable to filter the data according to the field.
I have attached the sample
I understand from the data that the ECI - 2964 and 4499 are present in all the Customer Data Quality dimension.
But only in CIP City is it occurring every month