Hello everyone, I am struggling with one calculation and how best to combine data under one date field in order to come up with the result similar to the image below. I was thinking of having sales per day but then was not capable to aggregate correctly under each month :-( appreciate any quick hint or advice. Thank you very much!!!
11 answers
Thanks to @Rosario Gauna I had a feeling this feature was in Tableau Prep. I didn't read the entire blog post but it did help me @ https://rosariogaunag.wordpress.com/2021/09/20/generate-rows-with-tableau-prep/
The key is that you need Tableau Prep 2021.3.1 or later
You can see I did the calculation based on days between each
