Consultant’s Diary – Calculated Field Pro-tips

I’m going to try and share some of the techniques and methods I use as a consultant. Using Tableau & Alteryx daily means that I’ve found I take small techniques, tips & tricks for granted. Hopefully this will be useful for you all.

Using Tableau almost everyday means you pick up a few shortcuts. Here’s some of my favourites when it comes to calculated fields.

Between placements during my time in the Data School, I sat in on some training. Between creating a Pareto whale and supporting DS4, I wrote a quick blog about the 7 ways to create a calculated field in Tableau. Check out this post – and let me know if I’ve missed any – you’ll find some others in the comments on that post.

What I want to share in this particular post is other shortcuts I typically use as I work on a piece of work in Tableau. Let’s get started:

Setting up my calculation window

When you install a fresh new version of Tableau Desktop, you are presented with this fun pop up when you create a calculated field (using one of the ‘traditional’ methods) – but I personally hate this view. I much prefer clicking the little arrow on the right hand side which pops out a menu:

This is for two reasons; the first that you are able to see the explanation of each type of calculation – which I find super useful when both explaining the logic to others, and working out the logic for myself; and second you are able to see the syntax of the function you will use. The fact that each function is organised into sections is also useful, particularly given different functions have different affects on different field types.

Visual Cues

Tableau is full of visual cues –  From the small icons for field types, and elements on a measure to indicate different manipualtions – I’m thinking the Table Calculation triangle, the Set venn-diagram and the Forecast arrow.

Within the calculated field window, this is no different.

Let’s take  the above  as an example;

• [State] and [Sales] are orange given they are fields within the data source
• ‘New York’ is grey given it is a string
• SUM( ) is blue given it is a function

Other examples include:

• Purple for parameters
• Black or grey for ‘literal’ functions – for example #2018-05-01# returns the ISO formatted date or TRUE/NULL, as well as numeric literals (ie. 1.45 or 12)

Documentation Pro-Tips

When documenting calculated fields there are two pro-tips I’d like to share about adding comments.

The first one you might perhaps know about – this is where you use two forward slashes (//) to  write a comment within the calculated field. This is also useful for troubleshooting whether a long nested calculation is returning what you are looking for – by using // to ‘grey out’ parts of the calculation, and testing what value is being returned by each part.

The second is something I found when preparing for my Tableau Desktop Certification;

With this function, you’re able to add a comment to your calculated field;

Which looks like this when you hover over the calculation.

A useful example of this is to either give a quick indication of what the calculation is doing, or what is inside it:

What are your favourite calculation shortcuts?

London, UK

5 thoughts on “Consultant’s Diary – Calculated Field Pro-tips”

1. Hugue says:

Ravi Mistry London, UK, thanks so much for the post.Really thank you! Great.

2. Hatem says:

I particularly like the last one, never know about it. One thing I started to do is to use an underscore for all my calculated fields so that they are sorted on the top (e.g.: _fieldOne, _fieldTwo…etc.). Of course if you are grouping the fields by folder you can just throw all the calculated fields in one folder.

Cheers Ravi! 🙂

3. Bhavana says:

Wow, last comment super helpful about writing a formula in comment. Thanks.

4. Learner says:

Great Post..I did not know about the comment thing..Thank you so much for posting it..

1. Ravi Mistry says:

A pleasure!