Good morning. I would like to know if it is possible to use the 'Representation - Indicator' to indicate if today's sales are greater or less than yesterdays? I am able to achieve this by changing the number format by using 'chr(9660)&'#,##0')' or 'chr(9650)&'#,##0')' and then defining the text color expression to be red or green.
I think is should be simpler to use 'Representation - Indicator', but I am unable to get it defined correctly. The below expression is what I am using.
If I use similar logic in the 'Representation - Indicator' it does not return correct arrow results.
I am able to get the 'Representation - Indicator' to work when I define a GP% upper and lower bands or where values are less that or greater than specified number. Maybe what I am trying to do is not for the 'Representation - Indicator'.
I'm experiencing the same issue. I would love it to be able to use the indicator to compare to a period of time before the presented value.
It seems to me that the indicator, like you said, can only be specified with a given number instead of working like the background colour of a measure for example where it also takes the dimension you use into consideration when defining the colour.
I hope this is a functionality yet to come, otherwise I feel like this is a missed opportunity.