7 Replies Latest reply on Mar 7, 2016 2:35 PM by Bin Xiao

# How to make % increase or decrease

Dear all,

I want to achieve something like followings:

Step 1. Count the number of activity in a time frame (filter, could be 7 days, 10 days, 14 days, etc.)   --- I know how to do this part

Step 2. Calculate the percentage change: compare the count from this time frame to last time frame (for example, if my filter was 2 days, then compare the count this 2 days ï¼ˆMarch 7 and March 6)  to last 2 days (March 5 and March 4).

Step3: If the percentage is up, I need to mark that number as red and have that up arrow; If the percentage is down, I need to mark that number as green and have that down arrow

Thank you very very much for your help!

Best,

• ###### 1. Re: How to make % increase or decrease

Anyone knows how to do that? Thank you very very much!!

• ###### 2. Re: How to make % increase or decrease

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

1 of 1 people found this helpful
• ###### 3. Re: How to make % increase or decrease

Hi Joe,

Thank you very much for your response! Do you have any attachment?

• ###### 4. Re: How to make % increase or decrease

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.

• ###### 5. Re: How to make % increase or decrease

Anyone knows how to do that? Thank you in advance!!

• ###### 6. Re: How to make % increase or decrease

Hi Bin,

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.

• ###### 7. Re: How to make % increase or decrease

Hi Chris,