8 Replies Latest reply on Sep 12, 2018 2:48 PM by GeneBurns

Year over year growth

GeneBurns Sep 12, 2018 1:02 PM

I have posted a line chart below that shows a running sum of daily tax receipts. Running sums for different years are currently set up so that you can see where you are in one year compared to the last. To accomplish this I used makedate function so the fiscal years could be compared side-by-side. However, I can't seem to figure out how to create a calculated field or some other method to display the growth rate of different taxes for each data point. Does anyone know how I can make that work? Do I need to set this up differently or is there a way to set up a calculated field?

I've gotten this to work in other circumstances, but I must be missing something in this workbook. A link to the document is available below. Thanks

Tableau Public

1. Re: Year over year growth

Shinichiro Murakami Sep 12, 2018 2:07 PM (in response to GeneBurns)

Hi GeneNurns

I'm not quite gotten what you want.
Are you talking about specific worksheet in you book or it's not created?
Could you illustrate what is current issue and what is your expectations.

Thanks,
Shin
Like Show 0 Likes(0)

Actions
2. Re: Year over year growth

GeneBurns Sep 12, 2018 2:16 PM (in response to Shinichiro Murakami)

I'm trying to get the correct growth rate (shown as 1205.7%, this is not correct) in the chart linked to above (photo shown below). Previously I've used the formula below and computed on the cash fiscal year, but that isn't working with this setup. Does this help?

(LOOKUP([Running Sum],0)-LOOKUP([Running Sum],-1))/LOOKUP([Running Sum],-1)
Like Show 0 Likes(0)

Actions
3. Re: Year over year growth

Shinichiro Murakami Sep 12, 2018 2:26 PM (in response to GeneBurns)

Which sheet is this in your book?

Sheet 14 already has right value

With this table calc setting

Shin
Like Show 0 Likes(0)

Actions
4. Re: Year over year growth

GeneBurns Sep 12, 2018 2:25 PM (in response to Shinichiro Murakami)

Sheet 14
Like Show 0 Likes(0)

Actions
5. Re: Year over year growth

Shinichiro Murakami Sep 12, 2018 2:35 PM (in response to GeneBurns)

Seems like kind of bug on public. it shows incorrect value on your link. but
With changing the table calc to this way, public on my page shows correct value,.

https://public.tableau.com/views/testGeneralFundpost/Sheet14?:embed=y&:display_count=yes&publish=yes

Thanks,
Shin
Like Show 0 Likes(0)

Actions
6. Re: Year over year growth

GeneBurns Sep 12, 2018 2:35 PM (in response to Shinichiro Murakami)

I'd like to compare a date in 2019 to a date in 2018. So I'm computing using the prior fiscal year and getting 1205.7%.

I must have published a version calculating using table across. That isn't my goal.
Like Show 0 Likes(0)

Actions
7. Re: Year over year growth

Shinichiro Murakami Sep 12, 2018 2:38 PM (in response to GeneBurns)

Confused, what's the right value?

Shin
Like Show 0 Likes(0)

Actions
8. Re: Year over year growth

GeneBurns Sep 12, 2018 2:48 PM (in response to Shinichiro Murakami)

Shin, I think I figured this out. I needed to change the nested table calculation for "running sum" within the year over year value. I'm going to do some double checking and mark this as answered. Thanks!
Like Show 0 Likes(0)

Actions