I would like to show the monthly median sales for every month in a year, e.g. 2017. If there were no sales, it should be 0 for that month.
How do we achieve something similar as below?
6 answers
Hi Kristof,
I believe you can get what you need if you utilize a date scaffold.
There are some good resources on scaffolding online:
- This post on the forum links to several resources: Data Scaffolding in Tableau
- There was also a video at TC18: Solving tough time-based problems with skeleton tables and Tableau Prep - YouTube
- The link below does the process with the superstore data set, so it might be an easy introduction:
- https://www.kenflerlage.com/2019/03/date-scaffold.html
Please let me know if this helps!
Thank you,
John
