Contact

info@theinformationlab.co.uk
t 08453 888 289

One Alfred Place
London
WC1E 7EB

Newsletter

Subscribe
« Show Me! - When less is definitely more | Main | Blue things and Green things »
Wednesday
Dec072011

Making Table Calculations work in Tableau

 

Slide1

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.  

 

GET THE WORKBOOK HERE

 

As always, if you need more help – please contact us @ The Information Lab.

 

Or if you want more content like this:

 

SIGN UP FOR OUR TABLEAU HELP NEWSLETTER HERE

 

Reader Comments (2)

Can you make the workbook available in Tableau Public?

December 13, 2011 | Unregistered CommenterPaul Hare

Tom,

Thanks for posting this! It's the best explanation of table calcs I've ever read. This will make for a great training session for either our users internally and/or for ATUG.

I have only used the "advanced" option occasionally, but now I will definitely be using it all the time. It doesn't make any sense NOT to use it.

Andy

December 28, 2011 | Unregistered CommenterAndy Kriebel

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>