Thanks a lot for the inspiration The one I used is a combination of the bullet chart: PY as a bar chart in the background in light grey, CY also as a bar chart in the middle and the ref line I put the budget. Usually for the CY, if we are above budget I put dark grey and if below budget orange.
Hi Andy - Amazing video, I just wanted to say thank you for the content you have produced and the for 1-2-1 responses you have given me personally on TH-cam over the last few months. You’ve helped me more than you know and I just wanted to say thanks. Loving the dual axis podcast too 😊. Great listen on my way to work.
Thanks Andy. Your tips and tricks are so useful and I often refer to your videos for my day-to-day work. Kudos to you and keep posting awesome Tableau content. Cheers!
Hi Andy, thanks for the amazing video, I just switching from power BI and now starting to learn some tableau. And I’ve been wonder is there anyway to conditionally change color with two measure underneath for PY and plan differently , I’ve learn some trick from your video by conditionally change for whole table but not in two individuals measure
Hi Andy Alwz love your tips in Tableau it helps me a lot in improving. Could you please hep me in comparing dynamic current month of financial year v/s previous moth of financial year using dynamic parameter for selecting Financial years
Hi Andy! A great tutorial as always! Thank you for your great work. One question: On the Sales CY Calc, what do the curly brackets do? {MAX(YEAR(DATE))}? Thanks!
Good question. The { } represent a level of detail expression (LOD). Wrapping the function in those will allow me to look at the entire data set to get the overall max since I did not specify a dimension to fix on.
thank you for this video. How can we adapt this comparison system with a filter (single chip) to know if 2022 is selected, we compare to 2021 etc... depending on the user's choice.
Hi Andy! Would it be possible to add the actual number of Variance to Last Year % to the data label in bullet graph, BUT not to the reference line but after the actual CY sales number next to the bar? So that I could see right away that those 200K sales are 20% off from LY results?
Hi Andy, Is there a way to show previous year value in a current month chart. I created a calculated field to get previous year goal and would like to reflect it in a current month chart, however, when using my cf it shows blank values. It only works if the previous year is in view. Thanks
Can you make a video on how to create a funnel chart for for cart to checkout using google analytics data if that’s something you can if now we could do a normal funnel chart 💪🏾💯👏
Hi Andy, can you show it again with fiscal year? For this the {Max(Year([Date]))} formula won't work. Even worse Tableau sets the fiscal year +1 (Feb 23 = fiscal year '22 but Tableau sets '23). And relativ filters like "last year" won't work, too. Thank you in advance and looking forward seeing a video for this problem from you 😉
Hi Soren, I ran into similar issue and came to know that Tableau date functions do not work as expected on a date field that is set as Fiscal (through default property setting). I was able to work around by manipulating the date itself for e.g. MAX(YEAR(DATEADD('month',11,[Date]))) if the Fiscal year starts from Feb. Hope this helps!
@@parthvora3628 thank you very much. I used this before but I run into problems when using context filters. And just Dateadd('year',-1,[date]) and changing this to fiscal year doesn't work as expected, too when it comes to year2date vs prior year2date calculations. And my goal is switching between the year and the fiscal year by parameter.
i had a hard time understadning bands at first but after watching your video i can do this now in under 10 secs lol thank really appreciate it
Glad I could help!
Thanks a lot for the inspiration
The one I used is a combination of the bullet chart: PY as a bar chart in the background in light grey, CY also as a bar chart in the middle and the ref line I put the budget.
Usually for the CY, if we are above budget I put dark grey and if below budget orange.
That’s a good one! Nice!
Hi Andy - Amazing video, I just wanted to say thank you for the content you have produced and the for 1-2-1 responses you have given me personally on TH-cam over the last few months. You’ve helped me more than you know and I just wanted to say thanks. Loving the dual axis podcast too 😊. Great listen on my way to work.
That’s so nice of you to say JD!! Thanks for the feedback and for asking questions.
Thanks Andy. Your tips and tricks are so useful and I often refer to your videos for my day-to-day work. Kudos to you and keep posting awesome Tableau content. Cheers!
My pleasure. Thanks for the kind words.
Love your Tableau tips and tricks Andy. I learn so much from your videos! awesome videos as always!
Thanks so much!
So visually appealing!
You are a gem andy!
This is the kind of stuff I've been looking for.
Fantastic!
Hi Andy, thanks for the amazing video, I just switching from power BI and now starting to learn some tableau. And I’ve been wonder is there anyway to conditionally change color with two measure underneath for PY and plan differently , I’ve learn some trick from your video by conditionally change for whole table but not in two individuals measure
Thanks for the tips!
You’re welcome
That is cool Andy! Thank you :)
My pleasure!
Yes Andy I would like to see more Chart type
Which chart types do you like to use?
Hi Andy Alwz love your tips in Tableau it helps me a lot in improving.
Could you please hep me in comparing dynamic current month of financial year v/s previous moth of financial year using dynamic parameter for selecting Financial years
Thanks a lot! Very useful!
Hi Andy! A great tutorial as always! Thank you for your great work. One question: On the Sales CY Calc, what do the curly brackets do? {MAX(YEAR(DATE))}? Thanks!
Good question. The { } represent a level of detail expression (LOD). Wrapping the function in those will allow me to look at the entire data set to get the overall max since I did not specify a dimension to fix on.
@@vizwiz Makes sense. Thank you!
thank you for this video.
How can we adapt this comparison system with a filter (single chip) to know if 2022 is selected, we compare to 2021 etc... depending on the user's choice.
Smart! very inspiring. thanks.
My pleasure!
Hi Andy! Would it be possible to add the actual number of Variance to Last Year % to the data label in bullet graph, BUT not to the reference line but after the actual CY sales number next to the bar? So that I could see right away that those 200K sales are 20% off from LY results?
Hi Andy, Is there a way to show previous year value in a current month chart. I created a calculated field to get previous year goal and would like to reflect it in a current month chart, however, when using my cf it shows blank values. It only works if the previous year is in view. Thanks
In this video, you would swap out sales in the previous year for budget. That should do it.
Can you make a video on how to create a funnel chart for for cart to checkout using google analytics data if that’s something you can if now we could do a normal funnel chart 💪🏾💯👏
Hi Andy,
can you show it again with fiscal year? For this the {Max(Year([Date]))} formula won't work. Even worse Tableau sets the fiscal year +1 (Feb 23 = fiscal year '22 but Tableau sets '23). And relativ filters like "last year" won't work, too.
Thank you in advance and looking forward seeing a video for this problem from you 😉
Hi Soren, I ran into similar issue and came to know that Tableau date functions do not work as expected on a date field that is set as Fiscal (through default property setting). I was able to work around by manipulating the date itself for e.g. MAX(YEAR(DATEADD('month',11,[Date]))) if the Fiscal year starts from Feb. Hope this helps!
I don’t work with fiscal dates and never have. I believe there are examples on the forums.
@@parthvora3628 thank you very much. I used this before but I run into problems when using context filters. And just Dateadd('year',-1,[date]) and changing this to fiscal year doesn't work as expected, too when it comes to year2date vs prior year2date calculations. And my goal is switching between the year and the fiscal year by parameter.