Need help with your Tableau calculations? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909 Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
The double click on the measure to create a "measure values" table is amazing. No more unselected all my measures and then selecting 2 out of my 100 measures.
Hey thanks so much for this, I want to calculate qtd but we have only done April for this new quarter, by using your method , I’m get data until may.. for prior year - how do I get to compare only until April?
I would swap the reference to the TODAY() function to be the final day of last month. Here's a formula you can use to do that: DATEADD('day',-1, DATETRUNC('month',TODAY()))
Thank you for this. I have a question. I want to compare quarter to date thisyear vs qtd prior year but prior year quarter should have data of all the months. For e.g. if qtd for this year contains april and may, i want to have data in prior year qtd from april may and june. Kindly help. Thanks
Hey there, this was a really great tutorial (as are your others) - thanks! I do have a question I hope you could help me with on this issue. I'm close to completing a dashboard but I'm very stuck on trying to figure out how to get a previous quarter based on data filtered for a specific quarter (with other filters available, like Market, Business Unit and Year) I've tried PREVIOUS_VALUE, LOOKUP and a couple of date functions, but it nothing seems to be working properly. It seems like the trick is that I'm filtering values, so I can't access the built-in YoY Growth calculation that I could then tweak to Quarter. For my purpose, I'd like users to filter on the above variables, so that they could see Totals Units Sold (for example) for say, Quarter 3, Year 2023, US Market, Business Unit X, AND I'd like to show the QoQ Growth by accessing Quarter 2's Total Units Sold for all the same filters. Do you have any ideas on how to tackle it? Many thanks in advance!
Thanks Miguel! Consider using a Table Calculation filter so it "hides" the removed data and could still be referenced in a QoQ calculation. Here's a breakdown on how: onenumber.biz/blog-1/2023/11/1/how-to-hide-data-with-a-filter-in-tableau
Need help with your Tableau calculations? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909
Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
The double click on the measure to create a "measure values" table is amazing. No more unselected all my measures and then selecting 2 out of my 100 measures.
I'm so glad that you found that tip helpful!
Hey thanks so much for this, I want to calculate qtd but we have only done April for this new quarter, by using your method , I’m get data until may.. for prior year - how do I get to compare only until April?
I would swap the reference to the TODAY() function to be the final day of last month.
Here's a formula you can use to do that: DATEADD('day',-1, DATETRUNC('month',TODAY()))
Thank you for this. I have a question. I want to compare quarter to date thisyear vs qtd prior year but prior year quarter should have data of all the months. For e.g. if qtd for this year contains april and may, i want to have data in prior year qtd from april may and june. Kindly help. Thanks
All you need to do is adjust the prior year calc from this:
IF DATEDIFF('quarter',[Order Date ],TODAY()) = 4
AND [Order Date ]
Thank you so much 😊
@@venkyrangala You're welcome!
Thank you!
You're welcome!
Hey there, this was a really great tutorial (as are your others) - thanks!
I do have a question I hope you could help me with on this issue. I'm close to completing a dashboard but I'm very stuck on trying to figure out how to get a previous quarter based on data filtered for a specific quarter (with other filters available, like Market, Business Unit and Year)
I've tried PREVIOUS_VALUE, LOOKUP and a couple of date functions, but it nothing seems to be working properly. It seems like the trick is that I'm filtering values, so I can't access the built-in YoY Growth calculation that I could then tweak to Quarter.
For my purpose, I'd like users to filter on the above variables, so that they could see Totals Units Sold (for example) for say, Quarter 3, Year 2023, US Market, Business Unit X, AND I'd like to show the QoQ Growth by accessing Quarter 2's Total Units Sold for all the same filters.
Do you have any ideas on how to tackle it? Many thanks in advance!
Thanks Miguel! Consider using a Table Calculation filter so it "hides" the removed data and could still be referenced in a QoQ calculation. Here's a breakdown on how: onenumber.biz/blog-1/2023/11/1/how-to-hide-data-with-a-filter-in-tableau