Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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(Sum({<Date_Num={"$(=max(Date_Num-1))"}>} [#Qty]) =0 and Sum({<Date_Num={"$(=max(Date_Num))"}>} [#Qty]) =0,
Num(Sum({<Date_Num={"$(=max(Date_Num-1))"}>} [#Qty]),'#,##0'), //Color exp Black()
if(
(Sum({<Date_Num={"$(=max(Date_Num-1))"}>} [#Qty]) > Sum({<Date_Num={"$(=max(Date_Num))"}>} [#Qty])),
Num(Sum({<Date_Num={"$(=max(Date_Num))"}>} [#Qty]),chr(9660)&'#,##0'), //Color exp Green()
Num(Sum({<Date_Num={"$(=max(Date_Num))"}>} [#Qty]),chr(9650)&'#,##0') //Color exp Red()
))
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'.
Thank you - I appreciate any advice.
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.
Good morning.
Thank you for your reply. Because there was never any feedback, I thought I was the only person on the planet wanting to show this type of comparison as a indicator.
I definitely believe having this functionality under the 'Representation - Indicator' functionality instead of having to write this type of expressions would be a better option.
I need the exact same thing! Haven't found anything so far.