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!
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!
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
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... ruclips.net/video/SgH4dgGJd5o/видео.html
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"
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
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.
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.
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).
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?
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.
@@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?
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.
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Thanks for share your knowledge. You’re awesome. Greetings from Colombia.
My pleasure!
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!
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!
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!
As always, great explanations and many useful ideas for the KPI presentation. Thank you, Andy. Waiting for the next videos.
Glad you like them!
Excellent Andy ! Keep up the good work !
Many thanks!
Yes, this is the right way to learn!
I love your pace ! Great video Andy ! Thank you :)
Glad you enjoy it! It’s nice to see a comment from a colleague. 😁
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!
Liked and shared!
Thank you!!
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?
Superstuff Andy !
Thanks a lot Andy. It is very great and helpful ☺️☺️☺️☺️
Glad you think so!
Thank you, Andy! Could you please show WTD calculation as well please
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.
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.
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.
Helpful, thanks
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...
ruclips.net/video/SgH4dgGJd5o/видео.html
And thanks for the suggestion!
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"
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
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
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?
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)
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
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,
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.
I think this functionality is not there in Tableau Public web version, I have tried there :(
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.