I am trying to create a calculated field that would first calculate the % change from week 2 to week 1.
Second, based off the % change I want to average the % change from week 2 to week 1 for the last 3 years in order to help create my forecast.
How would I create a calculated field row for this? The 3 year average would then be used to forecast the next week based off actuals from the previous week.
The following thread looks are months instead of weeks but should help lead you in the right direction:
Re: Average % month-on-month change, using table calcs
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...