Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
tvisha
Creator II
Creator II

Updating Legend Names

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

 

tvisha_0-1657020207137.png

Thank You, 

Labels (1)
3 Replies
Or
MVP
MVP

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).

tvisha
Creator II
Creator II
Author

IT is like this,

 

tvisha_0-1657020668780.png

 

and in Category expression I just have this, =[Case Category]='A' or [Case Category]='B'

 

Or
MVP
MVP

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])