Table calculations – easily the most complicated tool available within Tableau, and consequently the most powerful.
If you’re not familiar with Table Calculations – they are used for all the ‘tricky’ bits of analysis your boss asks you for, but doesn’t really think you’ll be able to do.
Creating a Table Calculation usually starts with a request a bit like this:
“Hey, dataguy, I have an EXCEL file here. I’ve got a KPI which shows this month’s revenue compared to the average of the previous three months – I bet you can’t work that out in Tableau!!”
This could well require the creation of a calculation which ‘moves’ – i.e. performs some calculation on data which is not in the column or row where the answer is placed, but is ‘relative’ to it.
Tough stuff if you are new to data analysis, or new to Tableau.
So here it is, a REALLY simple primer in how to make table calculations work every time.
This content doesn’t lend itself to a blog post, so we’ve had to create a packaged workbook which you can download and open in Tableau… We hope you like it, and that it can kick start your analysis in Tableau.
As always, if you need more help – please contact us @ The Information Lab.