Great technique. Though at 12:46 I'd have chosen a different title for the dashboard, just to avoid any problematic historical echoes. Just "Solution" might work.
Perfect video, extremely helpful, well paced, and the extra detail with timestamped sections really helped. One thing I will mention to those replicating this, if you run into an issue with the y axis sizing with the spark-lines (either too little movement or off the graph) you can normalize the data. To do this I took: (SUM([Metric]) - WINDOW_MIN(SUM([Metric]))/ (WINDOW_MAX(SUM([Metric]))- WINDOW_MIN(SUM([Metric]))) *[Metric] being just any field you are using.* This ensures it takes the window max and min of each cell so it can properly normalize the data between 0 and 1. Then, same as the video, you can add your SUM([Metric]) onto text to give it the value on the line. Hope this helps! All credit to the Wizard Samuel Parsons for discovering this was even possible. (シ_ _ )シ
I loved it. I have used a lot of the concepts to create a Gauge chart on savings vs target. I decided not to go with the 80+1 partition because I needed the precise data, and also decided to go for the 30% blank option (70% gauge), then hardcoded the 70/30 and calculated how the colors should look like. I had to see it multiple times to get some parts of it, however, it was totally worth it. One tip: it has worked for me to remove the option of panning and zooming, so your dashboard does not zoom when you touch the mouse's trackball. To do that Map >> Map Options >> [uncheck] Allow Map and Zoom. This will save you some headaches.
Great video! I tried to reverse engineer this for what I am doing but running into an issue. I only want to create a pie chart and then a bar graph by day for volume of errors within controls we are building. I have 60 days worth of data so I am having trouble figuring out the 4 vertical bars you have and converting it to essentially 60 bars with varying volume each day.
Hi! Thanks for the feedback - take a look at the Map Layer Theory section - timestamped: 42:33 above. That will explain it all. Also, I am planning some new videos to cover this in more depth soon!
Hi Sam, Downloaded your work from public and it looks the notification sheet is missing on that workbook. Where can find a version that helps me understand how to build that pop up notification. Thanks
Great Video! Is there a way to make a static gauge chart then? For example, I have 2 targets to compare with the current value, and I did not want any dynamic parameters.
Is there any way I could make my axis wider for my text? It does not fit and the text is cut but when I try to grab the header and make it wider all of my axis get wider and that's not what I want. I want to independently resize only my axis where I have my text. If anyone has any tips let me know please ! thank you, it is a masterpiece video!
Hey Sam, this is amazing! I am stuck on the vertical bars....the bars on my end are all the same height! For the vertical bar - size calc, i used a custom formula instead of -sum(sales) as you used in your report. Any thoughts?
thank you so much for this!! can you help me understand why I can't get the sort to work? I even started from scratch from your workbook and after sorting, the pie did not change - white part stayed to the right
Might be a simple question, but how do you manage to apply the same color to both the shape and text in the KPI column without using Dual Axis? Thanks for the video, it's mindblowing!
On the Marks Card for the KPI, under Label and then Font, I have clicked "Match Mark Colour" So the text picks up the colour you have applied to the shape.
nice but I dont know how I will get start my draft since you did not show how the graph got the break down lines from the start. need to see from scratch from the top please help me as I need it for my job. thanks
when i tried to replicate the vertical bars design, all my table calculations were defaulting to reading down, not across, so the results were not 1 and 4. I've been looking at this all day and comparing to your original tableau file. I'm super stuck can't figure it out.
Hey Dan. If you have checked your calculations and cannot see any issues with them, then the next step would be to double check ALL of the Table Calculations set up, both on the Vertical Bars - Colour pill and the Vertical Bars - Axis pill. If that is not the issue, then check you have the pills all set up the same (Discrete or Continuous, Dimensions or Measures). Lastly, double check you have the Mark Type set to Gantt Bar and not a standard Bar.
Oh this is awkward... I didn't realize that all the nested table calculations can be configured directly on the Sales or Profit or Position pill... who knew? : - )
This was probably the greatest learning experience I've had with tableau. Mr. Parsons, you sir are a genius! This design is going to be my go-to in the future. Thank you thank you thank you!
Hi! Thank you for this tutorial. I have one question / request - I'm trying to drill down into the city level (clicking on a state would populate the cities in that state) but the sparklines become identical for each of the cities. Do you know how to fix this? I've tried playing around with the y-axis logic calculation, but haven't had much luck. Any insight would be appreciated, thank you!!
I'm simply amazed. This is one of the best dashboards I've seen so far in my tableau learning journey, and it comes with a tutorial? Sharing this with my teammates. Incredible work Samuel. There's so much to learn from this tutorial. Thank you so much for making this!
Takes you 12 minutes to get to Dynamic Zone Visibility, although very much useful it is way to much time before getting to the reason we are accessing your video. Most people accessing this video are professionals with limited time, not students in a classroom.
I expect this is more to do with your own computer settings than the video. I have no issues with hearing it on my own PC, even with the volume at 30%.
@@sparsonsdataviz am facing same issue.please add a bit more volume volume if possible because even at 100% volume is below normal.its like volume is going up down up down.so low frequency sounds are less audible.
Hi Samuel, your video is really helpful! Thanks to you I was able to build such a table because previously I had no clue how to do it. But I struggle with one issue. When I use dimension as a filter (in your case State) and choose only one to show the whole logic stops from working. All sparklines look the same. Maybe you have some ideas why it is happening? I would appreciate if you can help to solve this problem.
Hi Sam! This is a BRILLIANT tutorial. I did want to point out that you need to have the Y-Axis pill calc in place on the pane before you can set the sizing of the mini bar chart. If you don't, you won't get to set the manual or fixed sizing options in the bar chart pill - instead you will have just the normal Tableau sizing slider :) Also I note, trying to replicate this with some other data that that when I try use 'bar' it tries to plot the bar vertically rather than horizontally. Only Gantt Bar will work for horizontal. Not sure why that is occurring.
Hey Darragh. The Bar Chart should be plotting vertically. The trick is to the use the Size to actually plot the length of the bar and then Fix the bar Size to the Left.
Thanks for the enriching video. I have used your exact formulas but encounter a problem with X pointer Y pointer and angel pointer are not working correctly. The values calculated are incorrect and therefore the needle point at the wrong direction. I would appreciate if you can guide me what can be the issue
Hi Samuel, thanks for sharing this video, exactly what im looking for. 👍 Im trying to work on websites (domains) as my dimension, im not so sure how to get the logic of "first letter", im not getting 1,0 as my y-axis. hope to get some clues. thanks again!
Yeah, it is not necessarily a full proof solution. It is a good spot, because if you look at my workbook and scroll to South Dakota, the years 2019 and 2022 are placed next to each other, which isn't necessarily correct.
Love your content! One of the best tutorials on Tableau I have come across. Could you also please make a detailed video on how you built this entire dashboard and its UI
This is great Samuel! I am running into a problem when I try to add a bar chart along with all of these sparklines. It looks as though everything is aligning to 0 on my Y-axis instead of 0.5. When I add the bar chart it is a tiny little line. I am stuck with trying to figure out how to fix it. Any suggestions? Thanks again.
Samuel this is the best gauge I've ever seen on Tableau. greatly done. Was trying to replicate the approach with a Tableau connection to a datasource but I have no possibility to create the union with Dim no. which is building the segments and assigning an ID to them. Is there any way to replicate a similar logic without the usage of the external excel file? Or is there any way to remove the dynamic creation of slices (I may not need that for my project). (i.e. Through contants and calculated fields)? I can't get a clue. Thanks a lor for sharing this amazing example.
This is the most advanced tutorial on building views in Tableau I've ever seen. It's amazing how you could combine so many non-standard ways to build a viz into a single sheet that works just perfectly. Each tip you share here is a gold. Thank you so much for sharing this!
Is it possible to make a dynamic dial for this? I’m working on a project where the executive team would like to see different metrics in one single dashboard. As you can imagine, the values for the dials and targets change depending on the metric. How can one achieve that?
Hi Maralis, yes this would definitely be possible. Without seeing the data structure etc, I would suggest creating a parameter that lists the available metrics to chose from and then create a calculated field that pulls in the required metric depending on the parameter selections. So something like this: CASE [Parameter] WHEN 'Metric Name 1' THEN [Metric 1] WHEN 'Metric Name 2' THEN [Metric 2] etc etc END Then use that calculated field to base the gauge build off of. That way it would then run from the parameter selection.
@@sparsonsdataviz hi thanks so much for the feedback. Would this work with having multiple dynamic slices as well. I’m a little confused and I haven’t worked with gauges before. I would like to keep them as simple as possible. The extract also has various different types: %, integers etc.
Thank you for the video, it's great! My pie chart begins at the 12 o'clock position. I have checked the 4d. Division Sort calculated field and the calculation is correct. Do you have any idea why it isn't working? Thanks
Thank you Maëva, The first thing I would check is the the ordering of the division segments actually on the view. I'd turn on tooltips and run my cursor over the segments and make sure that the Divison No is running in sequential order from left to right, and that the largest segment is showing at the bottom in the centre. If that all checks out then the sorting has worked ok. Then if you are finding your pointer is pointing to the 12 o'clock position, then look at the "2. Angle_Pointer" calculation, and make sure everything in there is OK. I have made adjustments there in that calculation to make the pointer not begin from the 12 O'clock. Try those 2 things and see how you get on.
This is amazing and super helpful for newer Tableau users trying grow their knowledge and creative ideas for data visualization. Is there any chance you will upload more video like this, showing step by step how to build dashboard from data sets ? Thank you! 🙌
Hi Raul, yes this is the plan, I will definitely be uploading more videos like this and some that will build dashboards. There has been a little break because I have been ill and now I am preparing for my presentation for the Tableau Conference at the start of May. I will look to add another video or 2 before then.
@@sparsonsdataviz oh I’m sorry to hear that you are I’ll. I wish you a speedy recovery. Good luck at the conference. Thanks you again for your contribution to the community .