How I Compare YTD, QTD, MTD, WTD & Daily Sales in Tableau
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 2024
- In this Tableau tutorial, I guide you step-by-step through creating a daily sales dashboard that covers all critical time frames: Year to Date (YTD), Quarter to Date (QTD), Month to Date (MTD), Week to Date (WTD), and Today.
Learn how to calculate these metrics and compare them to previous periods, allowing for a dynamic view of your sales trends. This tutorial is perfect for sales managers, analysts, and anyone looking to gain insights from their sales data.
What You'll Learn:
- How to set up a simple daily sales dashboard in Tableau.
- Calculating metrics for YTD, QTD, MTD, WTD, and Today.
- Comparing these metrics to previous periods to identify trends.
- Tips and tricks to make your dashboard visually appealing.
No prior experience with Tableau is required.
I guide you through the process with clear and simple explanations.
DOWNLOAD THE WORKBOOK
public.tableau...
NEWSLETTER
Sign up for my newsletter. Every week I provide advice, tips, live stream videos, discounts on products I create, and much more.
Launch, grow, and unlock your career in data at andykriebel.com/
CONNECT WITH ME
linktr.ee/andy...
TABLEAU COACHING
Contact me for more information about 1:1 and group coaching sessions.
coaching@andykriebel.com
ARE YOU INTERVIEWING FOR A NEW JOB?
Contact me for more information about how I can help you prepare for that big interview.
coaching@andykriebel.com
This 11 minutes video has more information than these others entire Tableau Courses.
That’s great to hear. Should I create a course then too?
Yes Sir@@vizwiz
This material really speaks to the needs of leadership. I've been impressed by how your abilities to create content markups etc. have evolved over the past year! Great work and thank you so much for sharing.
What are your thoughts on comparing year-over-year at the start of the year, or at the middle of a quarter, month, or week? Given that a fully completed period is not being compared, it may prompt needless discussions with leadership regarding why the values are lower than those of the previous period. How might this dashboard be modified to prevent conversations of that nature?
Thank you, Andy!
My pleasure!
This is great Andy! Basic comparisons are super important. I wonder how we can do this by parameter if we have a lot of KPIs and same time want to pick the month of the year. I believe adding this fields for 5 different KPIs would not be super easy
Thanks Andy, I now understand why for YTD it is ok to use YEAR fucntion, but for QTD we can't use the Quarter function.
Thank you so much, Andy. Could you please make a similar video but use a filter by sales years?
Thank you so much, Andy.
Andy -The Boss 😱
Really helpful, thanks as ever.
Great Andy, but in real world most dashboards have filters and that's where these indicators get complicated, it would be great if you could upload a video with this scenario.
Filters for what? I don’t think most dashboards have filters. At least in my 20 years of experience.
Hi Andy
How can I make the YTD, QTD... automatic. I mean when there's a filter on the dashboard and selecting different options chnages the metrics to either a %reduction or %increase. I want the arrow symbols/colors to change automatically
Where do we use the date part and date trunc? I tried using the date part for QTD, MTD and WTD but I got the same results. I'm a bit confused about these two. Could you explain the difference?
This is gold!
How could I add a monthly filter to showcase a YTD up until a certain time frame?
Excellent video, please is it possible in a more dynamic way? For example, it is possible to choose the month and still see the MTD. Thank you very much!
Yes, absolutely
how can we compare YOY, CY QTD with PY QTD and Current Month with Prior year same month for both Sales & Margin ? could you pls make a video on this?
Wow!
That's a great explanation. Just wondering your YTD calculation will show value for current year but not for Year Till Date as you have to restrict sum of sales till current date of year not for full year. Please tell me if I am getting it wrong?
I created a new data in the data set so that it would look like the most recent date was today. th-cam.com/video/Y-n2caElOj0/w-d-xo.htmlsi=ZrNlO2JPojRmGAXO&t=23
Ohh okay. I missed this part. Makes sense now.
Thank you
Create your own course Andy🎉
I always have one. 😊 DM me on LinkedIn
Thank you so much
No problem
Great great tutorial
Thank you! Cheers!
Andy, i didnt quite get why you remove the Phone/Device Layout when you first opened the new dashboard tab. What is the reason for that?
I don’t want Tableau to change the view if it’s viewed on a phone.
Hi Andy - I've noticed you do the "Date" column often - I understand how it works, but am not quite grasping the why behind using it instead of Order Date. Is there a link or resource where I can find an explanation? I know its a "normalization" technique, but are there specific cases when it is more or less useful than the Order Date? ChatGPT told me "By following this approach, you effectively "normalize" the dataset's dates to the current date, making calculations like year-to-date or quarter-to-date much easier. This is particularly useful when you want to compare data across various time periods without manually adjusting the dates for each calculation." but I feel I am still not quite grasping why/when to do this.
I only do it so that the dates are more realistic and reflect the current date. You can use order date if you wish.
I really appreciate the simplicity of the approach, but this could be improved to be a more apples to apples comparison. Use previous YTD in place of the whole of last year as an example. Of course, each has its use depending on what you're trying to see, but if you want to know how current YTD, QTD, ect. corresponds to where the metric was at the same point in the previous period PYTD, PQTD, etc. will accomplish that more effectively.
Absolutely. I have other videos that do that.
Can you please add the link for referring videos?@@vizwiz
Is it possible to create this using floating?
Yes
Thank you, Andy!