4 Replies Latest reply on Oct 15, 2018 10:57 AM by Andrew Wolford

# How to add (or calculate) average of 'Percent Difference' on line chart?

Hi everyone,

I'm working on a requirement that has me stumped and could use a little help!

Below is a screenshot of the wireframe I'm attempting to re-create in Tableau.  I have also attached a stripped down workbook with the line chart and relevant data.

I've created the line chart, and have added the Quick Table Calc 'percent different' to it.  Easy-peasy.  The part I can't figure out is how to add the average of 'Percent Different' for the series, and can't tell if it's even possible.  The solution can be a bit flexible:  It could be adding this metric directly to the chart, or could create a separate tabular worksheet and float it over / next to the chart on a dashboard.  I can't figure out how to do this without creating a table that shows all the dates, sum(daily_uniques), percent different, and then the average of that.  Appreciate any help, thank you!!

• ###### 1. Re: How to add (or calculate) average of 'Percent Difference' on line chart?

Here's an idea, you could add a reference line, select the quick table calc and computation as Avg and display Value like so (bottom right),

Hope this helps.

Best,
Shiva.

• ###### 2. Re: How to add (or calculate) average of 'Percent Difference' on line chart?

Hi Andrew,

Different ways to handle it. Please find my approach stored in the attached workbook.

Let me know whether this works or not.

~Tushar

• ###### 3. Re: How to add (or calculate) average of 'Percent Difference' on line chart?

Hey Shiva - this is great!  Thanks so much for the help with this.

• ###### 4. Re: How to add (or calculate) average of 'Percent Difference' on line chart?

Hey Tushar - thanks to you too!  As you said, there are a couple of ways to handle it, it turns out.  I ended up using your approach in my dashboard, but both these solutions did the trick.  Thanks again!