Forum Discussion
Using Range Bins as Legend Categories
Hello, I am trying to use ranges that I've created from a nother calculated field. I am taking a distinct count of certain categories and then I've created a range out of this distinct count: M...
Thanks, Theo. I tried this as well, however, this also only display "0-2" as the only values even though that is not the case. This column doesn't display the correct values when in a table either. The IF statement I pasted above shows the correct values in a table, but doesn't seem to work as a legend.
thrillhouse then it's related to the measure that you referenced. Use the following measure and it will fix the issue:
Measure =
VAR _1 = COUNTROWS ( 'Table' )
RETURN
SWITCH (
TRUE () ,
_1 < 3 , "0-2" ,
_1 < 5 , "2-4" ,
"5+" )Hope this helps.
Theo
