4 Replies Latest reply on Apr 23, 2013 1:46 PM by Dave Otte

# What I am trying to do is calculate a difference in percentage from one graph to another and then place that difference into a single graph. Is this possible... So you can see on the graph on the left you can see the change from Yr. 4 to 5 is -16% but the gray on the left is -49% what I want is the graph on the left to have a line of that -16% change. Therefore the calculation would be \$249,488 // 1 Provider // -16%.

Any help would be great!

• ###### 1. Re: What I am trying to do is calculate a difference in percentage from one graph to another and then place that difference into a single graph. Is this possible...

Hi Dave,

This can probably be done depending how the data is set up. Is it possible to post a sample workbook (twbx file)?

-Tracy

• ###### 2. Re: What I am trying to do is calculate a difference in percentage from one graph to another and then place that difference into a single graph. Is this possible...

Tracy,

It will be hard to place it on here as we have sensitive information on this Tableau. I can tell you the variables if you think that would be helpful.

If you can tell me how the data would have to be set up to this I can work with that.

Dave

• ###### 3. Re: What I am trying to do is calculate a difference in percentage from one graph to another and then place that difference into a single graph. Is this possible...

Dave,

Are the Normal and Provider part of the same dimension? Or are these two different measures?

-Tracy

• ###### 4. Re: What I am trying to do is calculate a difference in percentage from one graph to another and then place that difference into a single graph. Is this possible...

They are part of the same measure BilledAmount