Anyone knows how to do that? Thank you very very much!!
1 of 1 people found this helpful
I tend to break these things apart into separate sheets and position the various sheets appropriately on the dashboard. I'm doing something like this now. I have a line chart. Next to it a crosstab of the month selected by the user. And with it, a status color that indicates a red-yellow-green. (The last one would be similar to your up/down arrows.)
With the computation of the status percentage I have an extra calc that essentially says this:
IF (the status percentage is within the green range) THEN "Green" ELSEIF
(the status percentage is within the yellow range) THEN "Yellow" ELSEIF
(the status percentage is within the red) range THEN "Yellow" END
I then put the color calc on the color shelf and set the color values appropriately.
I have made my color status sheet a CIRCLE format (which then adopts the appropriate color), but you can make yours a SHAPE format and pick up- and down-arrows for the respective values. (And if your percentage is ZERO, you could even have a horizontal arrow for that one.)
Thank you very much for your response! Do you have any attachment?
No, I just described what you can do.
I'd have to do a whole bunch of work to anonymize my workbook, and I don't have time for that.
If you have something I can work with, I can show you how to set it up in your example.
Anyone knows how to do that? Thank you in advance!!
If you create a workbook using the demo data then I can show you exactly, but I guess you're only stuck with Step 3.
I usually create a calculated field to check if the difference is >0 basically ...
if [pct diff] >= 0 then "up" else "down" end
then you can use that as the shape and the colour to get the indicator looking the right way.
Thank you very much for your response!! I am also stuck with the step3... Please help! Thank you soooo much!!