Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a filter in the expression for category type. Like Category "A" or Category "B".
=[Category]='A' or [Category]='B'. In the legend it is showing as -1 and 0, how can I rename it to A and B
Thank You,
I'm not quite sure what you're doing in the chart, but I'm assuming the values are the numeric interpretation of "True" and "False" - values are either matching your condition (Category = A Category = B) or they don't (any other category). In this case, -1 is the values with category A or B and 0 is all other category values. It sounds like you should be using Category as your dimension (or you should have two expressions, one counting for each category).
IT is like this,
and in Category expression I just have this, =[Case Category]='A' or [Case Category]='B'
Then the chart is correctly showing you the split between cases where that condition is true, and ones where it is false.
Perhaps you meant to use Category (as is, with no condition) as a dimension, and a measure of
Count({< Category = {'A','B'} >} [Case Reference Number])