How to display last 30, last 60 and last 90 day sales in Tableau? Past 30, 60 and 90 day in Tableau
Vložit
- čas přidán 16. 01. 2021
- In this tutorial, I have shown the calculation to get the last 30 days, last 60 days and last 90 days sales in Tableau.
Tableau Functions / Concepts used in this tutorial : Today, Date and IF condition, Year
Join our social media groups with below links:
Whatsapp : chat.whatsapp.com/BxHPImvY6yV...
Facebook : groups/42212...
Please do SUBSCRIBE to my channel.
Do let me your queries/suggestions in the comment section.
LIKE || SHARE || COMMENT
#tableau #tableaututor #tableauforbeginners
It's so good easy and understanding thanks for sharing ❤️
Glad it was helpful!
How would you account for days that doesn't have data? For instance, I have a data set where on 9/18/22 there were no orders so that date does not exist on my data.
Expecting you to do YTD MTD QTD and date functions use cases. Thank you.
Hi, Thanks for the feedback. Please check out below links
YTD - czcams.com/video/dq9v0IEf7Bs/video.html
QTD - czcams.com/video/eQcumkFoOS4/video.html
MTD - czcams.com/video/71qQCN19YgI/video.html
@@TableauTutor thank you ❤️
Hi, I want sample super store data set which contains the Data upto 2022 year. Please share the data set
This format not working for past 5 years data which I have in sample super store
Hi, im facing the issue at custom field ...though i have written [Order Date] >= TODAY()-30 and [Order Date]
Check you data, may you don't have data that returns True.
after this calculations how can we add customized filter buttons to the dashboard like 30 60 90 days buttons I tried using parametres drop down list but how to do with buttons instead of parameterss list
Hi Jawad, try using Parameter actions to show options as buttons
I would like to calculate 60 day revenue from the date field present in dataset. Not last 60 days. For ex: I have two year of historical data (1997,1998). I would like to calculate 60 day rolling revenue. For every 60 days I would like to display revenuePlease help me in finding the answer.
Hi, here is the solution for your query - czcams.com/video/X7VPIXAVVZ4/video.html
Let me know if you have any further questions.
@@TableauTutor Thanks for the reply.
How do I get sales on the last day of each quarter or month?
Please check out this video czcams.com/video/Grt2gBsjfBo/video.html
There has to be another approach to this... this makes the data very ugly as it displays 'True' in the results/dashboard. Trying to get hide the 'True' value from the results is entire separate battle..