I have visits to 10 different stores. I need a graphic like below that shows me cumulative visits to a particular store by week number (week 1,...,52):
- 2017 visits
- 2018 visits + a "run rate" based on the average weekly visits (in 2018) for the shop to forecast till the end of the year
- Target visits
In the annotations it needs to show:
- The difference of visits between 2017 and 2018 (actual)
- The difference of visits between 2018 and target (actual)
- The difference of visits between 2017 and 2018 (run rate estimate) at the end of year
- The difference of visits between 2018 and target (run rate estimate) at the end of the year
I need a graphic for each shop. The spreadsheet is attached that should have all that you need.
Hello Elie,
Can you please attach a workbook with what has been attempted. This helps the community assist with questions. Packaged workbooks: when, why, how
I would check out the following sections of the Online Help Guide about use of Tableau's Table Calculation
+ Table Calculation Functions - Tableau
+ Get Started with Calculations in Tableau - Tableau
Hope this helps!
Cheers,
Byrne, Patrick
Community Manager
Tableau Software
Become a Viz Whiz on the Forums! Support the Community and master Tableau.