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',