topic Updating Legend Names in App Development

Updating Legend Names

tvisha — Tue, 05 Jul 2022 11:24:37 GMT

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,

Re: Updating Legend Names

Or — Tue, 05 Jul 2022 11:28:57 GMT

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

Re: Updating Legend Names

tvisha — Tue, 05 Jul 2022 11:32:11 GMT

IT is like this,

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

Re: Updating Legend Names

Or — Tue, 05 Jul 2022 11:35:05 GMT

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