Super Advanced Tableau Tables 

No problem, thanks for watching and glad you like it!

@@sparsonsdataviz I remember when I realised (with some help from Simon Beaumont) that it was possible to have more than one mark per row, but this really is next-level

Amazing. Thank you for the feedback. I thought similar - I hadn't seen it done before. Ideally though, we would love Tableau to make this more of an in-built feature, rather than us needing to create solutions such as this.

Hope you find it helpful!

Thanks Jeff. Glad you liked it!

You're welcome

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.

Yeah, someone else pointed this out to me. I'll definitely pay more attention to that on my next video. It's all a learning process! Thanks for pointing it out and watching this video. 🙂

You're very welcome!

You're welcome!

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 .

Hi Dilesh, thanks for the feedback. To answer your question about Standard Dev lines to the sparklines, my initial reaction would be 'no'. Reason being, if you tried doing it via reference lines, those reference lines would appear on every column of the table, not just the sparkline you need it for. If you tried to add the lines via a Dual Axis, then you would need to some how control the position of those STD Dev lines via the Y-Axis Measure and identify when it Y-Axis measure needs to calculate the STD Dev values and when it needs to calculate the Sparkline value - I think that would be one level of complexity too far.

Did you solve this?

Hi Cheah ZY, If you are looking to change the workbook in its current set up to show Year sparklines rather than Month sparklines, then you will get a conflict in the Y-Axis calculation. The reason for this is because changing the Month Sparklines to Years, will result in the SIZE() calc return "4", just as it does in the Vertical Bar section. So the Y-Axis calc will look to utilise the part of the calculation that it is using for the Vertical Bars. You can of course alter that part of the calculation to (SUM([Sales]) / WIN_MAX(SUM([Sales]))) - so you normalise the sales (between 0 and 1). This would work. Note that changing the Months to Years, will mean you need to update the Table Calculations and also alter the date axis range (currently it was fixed) to automatic (to show all the years). Your other option if you wanted to keep the vertical bar calculation is to make use of putting the State First Letter onto Detail as part of that Year Sparkline marks card - then you could add the a new part of the Y-Axis calculation that stated IF the Size() = 4 and [Dimension Test] = 1, that would identify the Sparkline for Years, instead of the Vertical Bars for years. Lastly, if you wanted 3 different sparklines with different measures, then this becomes more problematic, because you will need to identify each individually, so potentially need two versions of the [Dimension Test] calculation. Sorry there isn't an easier explanation of this, but this really advanced stuff, so not easy to explain in a comment reply. Hopefully you find it helpful though.

@@sparsonsdataviz Hi Samuel, Thanks for the suggestion, for my problem, the 1st scenario is to create a line chart with 4 different lines for a range of years. (I.e. 2020 to 2023) but it seems to be very complicated when I try to get the 1st letter as details. In my workbook, I tested out with the calculation, it still showing me True although I do not plug in the details (i.e. 1st letter). Lastly I just do 4 different line chart and minimize the column header, placed in the dashboard to let it to have a 4 lines view for the same category as a temporary solution. For future workbook, your idea is really great to let me have these sparklines inside a table. Thank you!

@@cheahzy1215 Hi. I'm hoping my new video might be of help to you with this issue above. Let me know.

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.

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.

Awesome, thanks!@@sparsonsdataviz

Hi, thank you for the feedback. What you ask for should be relatively straightforward. You could change the Axis calculation for the Vertical Bars to a CASE Statement. Something like: CASE YEAR([Order Date]) WHEN 2019 THEN 1 WHEN 2020 THEN 2 WHEN 2021 THEN 3 WHEN 2022 THEN 4 END Then put this onto Columns, to replace the old Index calculation. I say it is "relatively straightforward" because you will also need to adjust the Table Calculations on the 'Sales or Profit or Position' pill on Rows, to take into account this new calculation / pill. Let me know if it works!

I have allowed download access again. I locked down my workbooks recently after finding some had been copied and passed off of other peoples work.

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.

Is whether the SIZE function calculates down or across dependent on how many dimensions are in the view? Or the order in which marks are added?

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!

@@danallison8745 Glad you found it helpful Dan! Thanks for the feedback!