How I Calculate Day over Day Change Excluding Weekends in Tableau
Vložit
- čas přidán 3. 08. 2024
- In a previous tip, I showed you how to calculate day over day change and build 3 KPI cards. ( • How I Calculate Day Ov... )
However, this does not cover the case when you need to ignore weekends. In this #Tableau tip, I show you how to calculate daily change excluding the weekends.
Copy all of the calculations and download the workbook here - www.vizwiz.com/2023/01/exclud...
===============
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
Hey Andy! Jellyman Education here! Also a Tableau CZcamsr
My name is Jed and I live in Melbourne, Australia. I signed up for your live events in mid March and can't wait to meet you!
I've learned so much from you over the years and you inspired me to also be an online trainer
See you there!
Mind-blowing clarity of expressions !
That's good to hear. I tried to do that more in this video.
The way of teaching is Superb....
That’s very kind of you, thanks! Is there anything in particular that you found beneficial with my way of teaching?
Excellent content and loved the detailed explanation. Thank you for sharing!!
Glad it was helpful! And thanks for the feedback.
Awesome, thank you
You're welcome!
Really well described and loved the start describing what is happening behind the scenes around day of the week
Good to know...thanks! I'll do my best to keep that going.
Thank you for this video. I am looking at creating something similar to calculate the first response time in customer support where weekends are excluded.
Glad it was helpful!
Thank you Andy for this excellent video. Very useful and very efficient even watched on my phone during my morning train commute 🙂
Glad it was helpful!
Another excellent tutorial, Andy!
Thanks for sharing.
My pleasure!
Thank you!
You bet!
Awesome job, Andy! Thanks for considering my question!
Any time! Thanks for asking!
@@vizwiz Had one more question for you....I'm being asked to find the sum of sales for the last 10 days excluding weekends. Ultimately, I simply want to sum the last 10 days of sales. This for some reason is confusing me. Any help here?
@@ryangarland251 that’s probably best to do via a table calc but it’s not very straightforward. Let me see if I can put a quick video together. It’s hard to explain in a response.
@@vizwiz No worries. Its funny how I can get more complicated calcs to work but the ones you feel are quite simple, give me the most trouble 😂. Thanks Andy!
@@ryangarland251 coming back to this now. Do you essentially mean the last 10 working days? Or today’s date minus 10 days and then exclude the weekends. So in some cases that could be 6 days.
Great video😃
Thanks 😁
Informative video Andy, if I may ask about something related to this topic if I want to count how many Fridays & Saturdays in a specific month since the weekend days in my region are Fridays & Saturdays, is it doable?
This will help me determine how many working days in that month to be used in other calculations.
GREAT video! The text table helped to understand what Tableau is doing with the calculated fields. Just to be sure... The [Order Date] filter showed up because we excluded some dates?
Correct 👍🏻
Picked up a Great example Andy.. Very informative
I've got a scenario where I have to compare the sales where the previous day could be any date where there is available data. How could we achieve this
All you should need to do is change the date in previous date calc I'm using with the date you want.
Hi Andy! Thank you for the extremely clear walkthrough. I'm trying to solve a very similar issue and this gave me some food for thought, but while this walkthrough gets me part way there it dosen't quite fit my need. I'm trying to create a view where my prior day counts show on the same row as my latest day counts, so that when the view is filtered to just show the latest day I still see the prior day numbers. Is that possible to do?
Hello Andy, can you please share with me the software you use for editing your videos? They look great btw !
Final Cut Pro
Hi Andy , could you help me with this. can we use parameters while blending from two different data sources. if yes please explain that
Parameters work across an entire workbook. They are not dependent on a data source.
Hi Andy, do you have any resources for the week vs week calculation/viz/r12-r24-r36-r48?
What does r12-r24-r36-r48 mean?
I work with weekly data (discrete date that ends on Friday). I’m assuming I can use this same logic to compare latest week to prior week? Also, how would you compare latest 4 weeks (so 4 rows of data) to the prior 4 weeks?
For comparing latest to prior, you can follow this tutorial but swap months for weeks. Your second question is 100% possible. You would need to use a couple of datediff calcs to determine which set of weeks each week falls into and then compare those results. Does that make sense?
@@vizwiz yes, thank you so much for the reply!
Hi Andy, I have a requirement where I need to calculate day over day for a month and finally sum all of them and show one number as kpi card, I used table calculations for day over day but to sum all we need to use lod, as table calc and lod can't be used I am stuck, as it's over a month of data I can't create 30 calculations for everyday and sum, it's not efficient, do u have solution
My requirements are complex, I just want to know how to do dayoverday without table calculations for many days like 1 month or 3 months
Hi Andy, I have data where weekends between two activities must be excluded. The two activities are "Sent to Voicemail" and "Voicemail Processed." I need to calculate the day difference between when "Sent To Voicemail" was sent and "Voicemail Processed" was processed, and if there is a weekend between the two, I need to exclude the weekend. I have only the time stamp and the phone number as data for these two activities. Please help!
If I understand your question, you don't have a date field, you only have time. So if that's the case, it's not possible to compare dates.