7 Replies Latest reply on Oct 4, 2018 6:03 AM by Diana Prado

# How to get % difference from an AGG?

Hello,

Thank you in advance for your help with this! I am trying to show the % difference for various KPIs from August vs previous 12 months. I have been able to do it with most of the values, but I can't get it right when using AGG values. Please find the Superstore tableau file attached where you can see where i am so far. You can see that the "% Diff. Profit Ratio" numbers are all wrong:

Thank you again for your help!

• ###### 1. Re: How to get % difference from an AGG?

Can you explain what is the expectation here?

• ###### 2. Re: How to get % difference from an AGG?

Hi Deepak,

Thank you for your response!

I am trying to get something like this:

Profit Ratio (12 Mo. Av) = %10

Profit Ratio (August) = %11

Profit Ratio (% change) = 0.1%

Normally, I have been using percentage points to show the difference. (EX: Profit Ratio ( % change) = 1 point.) However, I am unable to do this in tableau so I was just going to use the % difference instead. Please let me know if this still doesn't make sense.

Thank you!

• ###### 3. Re: How to get % difference from an AGG?

Diana -- the change in profit ration in your example should be 10%, not .1%

I'm seeing correct values (I think) in your workbook already.  Moving from 13.88 to 12.32 is a decrease of 11.3%  (November 2018 numbers.)

• ###### 4. Re: How to get % difference from an AGG?

Thank you, Joe!

You are right - my brain is clearly not working today. Thank you for the correction.

Do you happen to know how I could make it show the point difference? It is much easier to understand visually that way.

Also, I am looking at December 2018 and it is showing incorrect values:

Thank you,

Diana

• ###### 5. Re: How to get % difference from an AGG?

Right click on the pill and choose FORMAT:

• ###### 6. Re: How to get % difference from an AGG?

... and then you'll get a format panel for that pill:

Pull down and select percentage and select the number of decimal places...

1 of 1 people found this helpful
• ###### 7. Re: How to get % difference from an AGG?

Thank you, Joe!!