How I Calculate Day Over Day Change in Tableau
Vložit
- čas přidán 18. 01. 2023
- In this tip, I going to show you how to build 3 different KPI cards for measuring day over day change.
In just a few steps, I’ll show you how to calculate:
1. Sales for the most recent day
2. Sales for the previous day
3. Difference in sales between those two dates
4. Percent difference in sales between those two dates
I'll then show you 3 different methods for displaying the KPIs so that you can create those that are most useful for your audience.
RESOURCES
• Workbook - www.vizwiz.com/2023/01/day-ov...
• Data - data.world/vizwiz/sample-car-...
• Month over Month Change - • Using LODs to View the...
• Year over Year Change - • Using LOD Calcs to Com...
===============
ABOUT THIS CHANNEL
This channel is dedicated to making you great at Tableau and introducing you to careers and influential people in data.
SUBSCRIBE
/ andykriebel
MORE TIPS & INTERVIEWS
www.vizwiz.com/
www.dualaxispodcast.com/
FOLLOW ME ON SOCIAL
Get updates or reach out to get updates on my social media profiles!
Twitter: / vizwizbi
LinkedIn: / andykriebel
Facebook: / vizwiz
Spotify: spoti.fi/3Sw5i5D
Apple Podcasts: apple.co/3yj7y89
Google Podcasts: bit.ly/3yiz0mq
Amazon Music: amzn.to/3yk27Wy
===============
MY EQUIPMENT
** Blue Yeti Microphone
amzn.to/3SjnjCX
** Endurax 66" Video Camera Tripod
amzn.to/3F4ogMy
** iPhone 13 (camera)
amzn.to/3VP01YA
** Neewer® 700W Professional Photography 24"x24"/60x60cm Softbox for Lighting
amzn.to/3VJLoGa
===============
CREATE GREAT CZcams CONTENT
🎬 Part-Time CZcamsr Academy - Ali Abdall's 6-week live online course on becoming a part-time CZcamsr
ptya.samcart.com/referral/IKj...
📚 More great courses from Ali
ptya.samcart.com/referral/7he...
===============
DISCLAIMER
This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. Proceeds go to producing content for this channel. - Věda a technologie
I love your pace ! Great video Andy ! Thank you :)
Glad you enjoy it! It’s nice to see a comment from a colleague. 😁
As always, great explanations and many useful ideas for the KPI presentation. Thank you, Andy. Waiting for the next videos.
Glad you like them!
Thank you so much, Andy, for making this video when I ask you. It helps the full video. Once again Thank you, Andy.
Happy to help! Thanks for asking!
Excellent Andy ! Keep up the good work !
Many thanks!
Yes, this is the right way to learn!
Thanks Andy for this wonderful tutorial, very practical cases you are taking on here, I'm definitely getting better and better on Tableau🙏
Great to hear!
Thanks for share your knowledge. You’re awesome. Greetings from Colombia.
My pleasure!
Thank you for the informative and knowledgeable videos. They help to expand our understanding and deepen our knowledge on Tableau.
Keep up the great work!
So nice of you...thanks!
Great content as always. Keep rocking Andy. Greetings from Brazil
Thanks, will do!
I love the one-sheet KPI with bar! I just used it to visualize door-to-discharge minutes for an urgent care center (fewer is better, so my color palette is opposite). I can't wait to show my client--I think it's really effective!
Fantastic! What did they think?
Thanks a lot Andy. It is very great and helpful ☺️☺️☺️☺️
Glad you think so!
Great video, thanks! Now I need to go and watch your Month over Month Change and YOY Change videos.
Please do! You’ll find them very similar. The links are in the description.
@@vizwiz will do!
Liked and shared!
Thank you!!
Helpful, thanks
Superstuff Andy !
Thank you, Andy! Could you please show WTD calculation as well please
Great content Andy, very very usefull! I have a question , what if we use aggrageted value instead of sales ? Like count of distinct customers ?
Where I have a SUM, you would use the COUNTD
Great stuff as always, Andy! Come On you Chels! Can you do a video where to show prior day sales but excluding weekend? Example, today is Monday and need to display Friday ales but in an easy calc.
Yes, possible, but definitely more complicated. The method I’m using looks at the literal previous day. I know you can do it with a table calc, but as I type this, I’m thinking you could change the -1 to -3 if the latest day is a Monday. So -3 when the latest day is Monday, -1 when it’s any other day. Does that make sense?
@@vizwiz It does, in the meantime, I just did a CF as a filter using the following: DATEPART('weekday', TODAY()) = 2 AND [Date] = DATE(DATEADD('day', -3, TODAY()))
OR
DATEPART('weekday', TODAY()) IN(3,4,5,6) AND [Date] = DATE(DATEADD('day', -1, TODAY()))
Def more complicated and took a bit to figure out but managed to get it to work
Here's a blog post for you that I've just uploaded. The video is on the blog too.
www.vizwiz.com/2023/01/exclude-weekends.html
Or if you just want the video...
czcams.com/video/SgH4dgGJd5o/video.html
And thanks for the suggestion!
Hey Andy, this is great! How can i get this to work on an aggregated calculation?
Same way. Just don’t aggregate inside the LOD.
i got it working - i have left out the curly brackets which is why it wasnt working - i cant help notice adding the {} brackets changes the calculated from a measure to a dimension is that the main function of using {} brackets ?
thank you for your time
Great tutorial 😊,
I had succeeded in getting result in first place, however when user select a date it is showing zero in previous day column! Advise please.
I am facing this issue...how to tackle it?
awesome, one doubt at 10:13 why you dropped the measure name to view? What is the thought process?
So I could show the names of the measures.
Thanks, Andy! That is awesome. What application are you using to recorde videos, edit, and add animations to your recordings? See you a'll at TC23!
Final Cut Pro for editing (I use an editor). Video of me is done with my iPhone or a webcam using OBS and the screen is recorded using Cleanshot (I’d highly recommend it).
@@vizwiz Thanks Andy. Appreciate all your efforts.
Hi Andy thanks for this tutorial however i get an error at an early stage at 2:13 mins in the video
i have a date field called Wk_Starting_date and i am using that instead of your Day field against my calculated field "Latest_Wk_Date" but when i times it by my value it gives me an error saying - "Cannot mix aggregrate and non-aggregate arguments with this function"
Thank You for this. So I have tried this but now for months, while the latest is showing the correct figures, the % change is not indicating anything while the previous month is showing 0.
I have actually been able to crack it. 🙂
Good to hear
How would you handle having to work with an aggregate in the Sales Latest Day Calculation? Let's say your Total sales are made up of the reported sales from two locations.
I'm getting a error there because I can't use aggregate & non-aggregate together
Don’t aggregate inside the LOD if your data is already aggregated.
Hi Andy,
I am using a date filter(Selected over range) and when I am sliding the date lower than the maximum date, the method is not working as Max date is selected over the entire dataset. Could you please suggest what shall I do?
Add the filter to context.
Hello good evening, I would like to count service orders and not sales value, is it possible to do it the same way?
Yes. Use countd([orders]) instead of Sum(Sales)
When the day is monday compare change with friday and if not compare with yesterday...
But it not based on only max date means user want to select date from filter and i.e single date or multiple dates....how to acheive this.
I don’t understand your questions. Sorry.
When i am creating calculated field Sales Latest Days getting this errors - "Cannot mix aggregate and non aggregate arguments with this function"
That means one of the fields is aggregated and one is not. The LOD needs a SUM around it. Have another look at the video. 👍🏻
@@vizwiz I don't understand this part. My sales value in your example is an aggregate already. What can I do to make this calc work with an aggregated sales value?
I'm perplexed, about data school.
I have seen some interviews, but confused here - paid for learn 🤔
100%...that's correct! Check it out thedataschool.com
I have some quires.. Can we get through what's app or other thing.
@@rajeshpanwar8945 check the website. If that doesn’t answer your questions (there’s an FAQ), then you can email the DS.
Thanks Andy for sharing. I am just amazed with the numbers of steps it take to do the last example. If someone who doesn’t have the experience like you, it would probably take days just to figure out with all the different options in tableau to do that last one.
@@okentan Yeah, it's not exactly straightforward, but that's also why I create the videos. Hopefully people can follow along if they like the look of it. I wouldn't expect someone without quite deep experience to know how to do it.