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