Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'd like to split a measure into 3 categories to use them as a filter, like so:
=if([% utilizzo fine mese]>1 or [% utilizzo fine mese] = '>100%','>100%',
if([% utilizzo fine mese]>0.85,'>85%', '<85%'
)
)
this code is working perfectly fine for the background colors of the column "% utilizzo fine mese" (where instead of the strings there are the colours), but for some reasons is not working when used as a filter selection.
The code is giving no errors, but when I try to use it, only the '<85%' appears and it doesn't work. I can click on it but it's not selected as a filter.
Thanks!
I'm sorry but filter panes only accept dimensions, not measures.
You might need a different way to achieve your goal, like creating a new field in load editor to flag [% utilizzo fine mese] with the desired options.
Hope this can be helpful
To create a filter, you will need to add an Aggr()
=Aggr(
if([% utilizzo fine mese]>1 or [% utilizzo fine mese] = '>100%','>100%',
if([% utilizzo fine mese]>0.85,'>85%', '<85%'
)),
[% utilizzo fine mese])
-Rob