Hi Everyone
I have been able to use conditional formatting using CASE statements to work around the maximum of 20 rules in Looker Studio. The rules are based on student percentile levels for each student year level from 2022-2026. Year 2 percentiles have a different threshold to Year 3 etc.
The issue is I have had to include dimensions in the table using calculated fields which are then included in the conditional formatting process. I have minimised the width of each of the dimensions but you can still see 5 columns of 1 character width in the table. I guess I would like them not to be there or be invisible. I hope this makes sense.
Thank you for your assistance.
Continuing the discussion from Unable to filter Null value entered:
Dear WK
Thank you for your help and the link as well. Luckily I was able to adapt Lauratiltonās solution, āFacing issues with Report Filterā which was similar to the filter issue like mine. It appears to have worked whereby a null input by a user no longer displays all results and the unique code only displays their childās results.
Thank you again for your help.
Kind regards
Ian