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.
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
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.
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..
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.
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
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
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 - ruclips.net/video/dq9v0IEf7Bs/видео.html
QTD - ruclips.net/video/eQcumkFoOS4/видео.html
MTD - ruclips.net/video/71qQCN19YgI/видео.html
@@TableauTutor thank you ❤️
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.
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 - ruclips.net/video/X7VPIXAVVZ4/видео.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 ruclips.net/video/Grt2gBsjfBo/видео.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..