Understanding Tableau Table Calculations using INDEX() and SIZE() – Part 1
Table calculations are important in Tableau, they help you to do more with your visualisations by providing calculations that bring in more data than is just in the current row. There are plenty of calculations that fit in this category, from TOTAL() through FIRST(), but I’ll wager one of the most under-used in SIZE(). This is in juxtaposition to the fact this was one of the calculations that showed up most in the Jedi sessions at the Tableau Conference in Seattle this month. With it’s partner INDEX() – which is very widely know and used among the advanced User community – you can do great things.
So SIZE() does matter! I plan to use the story points in the below workbook to describe what it does and how anyone, newbies through to Experts, can use it to improve their visualisations. It can also be a great way to learn about the fundamentals of table calculations, and a great way to be introduced to SIZE()’s friends: INDEX() and FIRST().
This is a first post to a wider post to show some great use cases for SIZE() and INDEX() – here is the second installment.
Click on the image below to view the Story.