I have a filter that I created which is based on an expression. I want this filter to only affect one table in my dashboard. The table should be affected by all filters.
Here is the expression.
=aggr(if(((((YEAR(DueDate)-PeriodYear)*12+(MONTH(DueDate)-PeriodMonth)))>=0 AND measure_result='1')
AND (((YEAR(DueDate)-PeriodYear)*12+(MONTH(DueDate)-PeriodMonth))<=3 AND measure_result='1'),'0-3 months',
if(((((YEAR(DueDate)-PeriodYear)*12+(MONTH(DueDate)-PeriodMonth)))>3 AND measure_result='1')
AND (((YEAR(DueDate)-PeriodYear)*12+(MONTH(DueDate)-PeriodMonth))<=6 AND measure_result='1'),'4-6 months',
if(((((YEAR(DueDate)-PeriodYear)*12+(MONTH(DueDate)-PeriodMonth)))>6 AND measure_result='1')
AND (((YEAR(DueDate)-PeriodYear)*12+(MONTH(DueDate)-PeriodMonth))<=12 AND measure_result='1'),'7-12 months',
if(measure_result='0','-Due Now',)))),member_id,measure_description,measure_result,DueDate)
I am basically filtering rows based on the date calculation.
Is this possible to do? I know that you can do this based on a field. Not sure if it can be done with an expression.
Thanks
