Skip navigation

Hi all, my name is Nicolas and I am a Graduate Analytics Consultant at Concentra. I'd like to share with you this dashboard on obesity admission episodes in England and the process I used to create it. If you're not familiar with Level of Detail expressions, check out my blog on the different types of LODs and their use cases before you go on reading.


After building a visualisation on Europe’s religious groups which would demonstrate a use case for Tableau’s Level of Detail expressions, I decided to create a blog using healthcare data to show how the same functionality can be applied to a range of topics.

The subject matter I chose to visualise was obesity rates in England, or more specifically hospital admission episodes with a primary diagnosis of obesity in England, by Local Authority in 2014/15. The dataset I used was the “Statistics on Obesity, Physical Activity and Diet – England 2014/15” published recently by the Health & Social Care Information Centre (HSCIC).

Click on a local authority in the dashboard below and explore for yourself:


  • This dashboard was made possible with the following calculated field: “Total Number of Admissions by Gender”:



     This Fixed LOD works out the sum of people admitted to hospital with a diagnosis of obesity grouped by gender, regardless of what other dimensions are in the view. This is      an application of Proportional Brushing: the Fixed LOD lets you compare the selection (admissions in selected local authority) to the total amount (admissions in England).


     This is plotted in the fact boxes on the left:


  • Once this is calculated it is possible to work out the total number of admissions by gender, as a Percent of the TOTAL number of admissions, with the following calculated field:



    The result is plotted on the bar chart on the right:


  • The tooltips can also be exploited to add dynamically changing information according to which selected LA has been selected. Explore them and find out the number of admissions relative to the population of each LA.


     If you’d like to know more about the different kinds of LOD Expressions, Tableau offers some very useful resources around the topic: take a look at its “Understanding LOD      Expressions” white paper or the interesting list of example it created in its "Top 15 LOD Expressions" article.

Hi All,


I'm writing again to tell you about our most recent blog posts over at Concentra.




Tableau is all about easy to produce, aesthetically pleasing visuals, but there can be a vast difference between visualisations created with or without formatting best practices - as the latter often lacks a certain finesse. This blog will show the four stages of building a Tableau dashboard and what to consider in each of them in order to deliver a polished visualisation.




Level of Detail (LOD) expressions can be notoriously difficult to understand for people that use Tableau. There are three types of LODs: Fixed, Include, and Exclude. This blog will focus on the Include expression.


Visit our blog to see all of our posts: Blog | CONCENTRA

You can create a variety of file types when using Tableau, but do you know what they contain and when to use them best?


Check our newest blog to read a short and concise view of the range of tableau file types available, highlighting their use cases.


Check it out here and improve your Tableau abilities even further:


A Quick Guide to Tableau File Types: Features and Use Cases | CONCENTRA


Keep on the lookout for more tips from the Tableau experts at Concentra.

Laryssa Mariano

Great Tableau tips

Posted by Laryssa Mariano May 10, 2016

Hi All,


Concentra has been releasing great blog posts with Tableau tips to help you enhance your analysis.


These are the latest ones:


- 9 Tips to Use Tableau Like a Pro 9 tips that will help you rock and roll with Tableau.


- How can you Drive Tableau Adoption? 4 Red Flags to Ensure Success If you're about to start or are in the middle of your analytics project or technology implementation, check out these 4 red flags to make you stop and think before you charge ahead.


- How to Enrich your Tableau Visualisations with Mapbox The integration of Tableau with Mapbox allows users to take map customisation to the next level. See how you can use Mapbox to design beautiful and interactive custom maps in Tableau!


- A Quick Guide to Tableau Level of Detail Expressions OD expressions provide a way to easily compute aggregations that are not at the level of detail of the visualisation. Find out more about the various LOD types and business use cases from this blog.


Take a look and improve your Tableau habilities!