These two videos have transformed the way I approach dashboards. I used to waste a lot of time trying to line containers up using blank widgets and didn't understand why some containers would go haywire when I adjusted the dashboard while others stayed in place. Now I'm going through my legacy dashboards and ditching all the blanks. It's amazing how much better my chart elements align.
Hi Andy, thanks for putting these video's together. I love being able to follow along and complete a full dashboard along with the video. If anyone else was confused about where the sheets were if you right click on the dashboard tab and select unhide all sheets they open up.
Thanks for the additional containers video, Andy. Still working on "mastering" them! It's very valuable to hear you verbalize your train of thought, especially when things go temporarily awry.
Cannot remember where I saw the following tip but I saw someone putting a blank in every container they added to a dashboard and the colouring the background of the blank to a pastel colour. This made it very easy to see all the containers as well as providing an anchor point within each container. The blanks were then deleted after the rest of the contents of the container had been added. I have used this technique and find it useful with more complicated container layouts.
@@vizwiz Hi Andy, could you please make a quick video to elaborate on the idea Peter mentioned. If you have already, please point me to the material. Thank you!
@@HaiLeQuang The way they design the dashboard is at follow: (1) Draw on a sheet of paper the containers that they'll need (or you can use Excalidraw) (2) Drag in those containers into the dashboard and arrange them based on your design in (1). Once you can do (2) you can see that it's impossible to realize which one is which ( I think this is one of the limitations of Tableau). But if you drag in a blank and put color on it, then it becomes clear which one is which. The last step, (3), is to drag in the sheets with the vizzes and then delete those blanks. Hope it helps!
Hi Andy! Not containers related but was wondering if you could do a video showing the calculations for different types of common headline figures? :) Personally struggle quite a bit with coming up with calculations to get headline figures such as "Change in %" (E.g: Makeover Monday Week 10 IOC Games -- change in women participation), "Maximum Profit earned" etc.
Hi Hailey. There are quite a few videos on my channel related to this topic. If you search on my channel for KPIs, that should get you them. If not, please let me know.
These two videos have transformed the way I approach dashboards. I used to waste a lot of time trying to line containers up using blank widgets and didn't understand why some containers would go haywire when I adjusted the dashboard while others stayed in place. Now I'm going through my legacy dashboards and ditching all the blanks. It's amazing how much better my chart elements align.
Fantastic! I’m glad you found it helpful.
Hi Andy, thanks for putting these video's together. I love being able to follow along and complete a full dashboard along with the video. If anyone else was confused about where the sheets were if you right click on the dashboard tab and select unhide all sheets they open up.
Glad you enjoyed it!
Thanks for the additional containers video, Andy. Still working on "mastering" them! It's very valuable to hear you verbalize your train of thought, especially when things go temporarily awry.
Glad it was helpful!
Cannot remember where I saw the following tip but I saw someone putting a blank in every container they added to a dashboard and the colouring the background of the blank to a pastel colour. This made it very easy to see all the containers as well as providing an anchor point within each container. The blanks were then deleted after the rest of the contents of the container had been added. I have used this technique and find it useful with more complicated container layouts.
I love that idea! I'll be using that from now on for sure. Thank you!!
@@vizwiz Hi Andy, could you please make a quick video to elaborate on the idea Peter mentioned. If you have already, please point me to the material. Thank you!
Thanks Peter for the idea. I messed around with it and finally understood how to apply blank sheets to better control my dashboard design.
But what's the benefit of putting a blank as a placeholder?
@@HaiLeQuang The way they design the dashboard is at follow: (1) Draw on a sheet of paper the containers that they'll need (or you can use Excalidraw) (2) Drag in those containers into the dashboard and arrange them based on your design in (1). Once you can do (2) you can see that it's impossible to realize which one is which ( I think this is one of the limitations of Tableau). But if you drag in a blank and put color on it, then it becomes clear which one is which. The last step, (3), is to drag in the sheets with the vizzes and then delete those blanks. Hope it helps!
Thank you so much Andy, Appreciate all the effort you have put in
OMG! I thought I'm good at containers. However, this is true mastery! Thank you very much, Andy!
Great work Andy. Love these!
Thanks Andy for this Amazing video. I am new in Tableau and learning a lot from your videos. THANK YOU
Great to hear! Thanks for the feedback!
Thanks Andy!, this is so useful!
Glad you think so!
Learn quite a lot from the video! Thanks Andy!!!!
Great video but very confusing because I cant get the containers to work because you fixed the error without explanation.
Struggling with LY PY Total calculations on the worksheet os Sales, Profit and Quantity..... have you explained this too in any video?
Here you go Using LOD Calcs to Compare Latest Year to Prior Year
th-cam.com/video/YuxYr4_l2ww/w-d-xo.html
Hi Andy! Not containers related but was wondering if you could do a video showing the calculations for different types of common headline figures? :) Personally struggle quite a bit with coming up with calculations to get headline figures such as "Change in %" (E.g: Makeover Monday Week 10 IOC Games -- change in women participation), "Maximum Profit earned" etc.
Hi Hailey. There are quite a few videos on my channel related to this topic. If you search on my channel for KPIs, that should get you them. If not, please let me know.
Thanks this was helpful
Andy kindly explain this graph which states made less money this year??
Explain it how? What’s your question?
Why do you need to put blank objects as placeholders? What's the benefit?
The blank object, for me, makes it easier to place the other objects in the correct containers. I think I explain that in the video.
Can we please get a link to a workbook with all the sheets? thanks!!
The link is in the description.