5 Replies Latest reply on Feb 25, 2018 6:06 AM by luisa.bez

# Year-over-year growth slope chart

Hi,

I would like to display the year-over-year growth from 2006 to 2016 in a slope chart. Do I have to index the 2006 values as, say, 0% in order to get a slope chart that should look like the one with absolute numbers? If so how would I do that? Furthermore, which formula do I have to use in the tooltips to show the percentage difference? I've attached the Tableau 10.4 file which hopefully ilustrates what I mean.

Thanks,

Luisa

• ###### 1. Re: Year-over-year growth slope chart

Hi Luisa,

Did you try table calculation?

• ###### 2. Re: Year-over-year growth slope chart

Hi this can be done with a table calculation percent difference the formula is:

(ZN(SUM([Visits])) - LOOKUP(ZN(SUM([Visits])))) / ABS(LOOKUP(ZN(SUM([Visits]))))

for you it is important to start the calculation in 2006 see below

it will return this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

2 of 2 people found this helpful
• ###### 3. Re: Year-over-year growth slope chart

I didn't know about the "Relative to" function! Thanks so much for your help!!