If I have data that ranges from July 2017 to July 2018, what do I need to do so that I can show completed Quarters (July to September, October to December & January to March), but include April as a single month. So in the attached workbook, I could represent the following:
Q1=240
Q2=218
Q3=200
April = 82
Then one month from now, show Q1, Q2, Q3 but with the months of April and May individually. Then when I need to report on the whole year, I would show totals for Q1, Q2, Q3 and Q4.
I have attached a workbook with dates. Also, would it be possible if YAGO was added so that in the above example, I could calculate the YAGO for Q1, Q2, Q3 but with the months of April as well?
Hi Sergio,
Bryce and I both answered on this thread: https://community.tableau.com/message/774659?et=watches.email.thread#774659
Please see if our answers helps you with your challenge!
Thanks,
Mavis
Become a Viz Whiz on the Forums! Support the Community and master Tableau.