3 Replies Latest reply on Apr 19, 2017 7:43 PM by Galen Busch

Level of detail on sub-regions

@Hi All,

First of all thank you in advance. I've learnt quite a bit from this forum so really appreciate all the people who take time out to respond.

Here's an issue I'm having now.

In the attached workbook, I'm using Level Of Detail calculation on the SCH_ENBL_FLG_INT field so I can perform a % of total calculation (Scheduled % = SCH_FLG/SCH_ENBL_FLG_INT) in the top view. However I cannot use the same view at a regional level because for regional level data, I would like to see scheduled %  at a regional level vs using the total number in the d. For eg: In the bottom view of the dashboard, AMER All Day should show as 456 (SCH_FLG)/ 1243 (Total for AMER) but given it's using LOD, its calculating 456 over the total number of SCH_ENBL_FLG_INT.

Any ideas on how to get Scheduled % at a regional level in the Region view?

Tableau version: 9.3

• 1. Re: Level of detail on sub-regions

Hi Ashwin,

I'd love to help! It looks like you may have forgotten to attach the workbook.

Galen

• 2. Re: Level of detail on sub-regions

Attached now

• 3. Re: Level of detail on sub-regions

I believe the solution you are after is:

{FIXED [REGION]:sum([SCH_ENBL_FLG_Int])}

I suggest making 2 calculations. One is your denominator at the region level (above) and your current calculation is your denominator at the total level.

FIXED will pass the same value at any granularity of your view. It is helpful for calculating percentages in this manner. You can also do:

Sum([A])/Window_sum([B])

This is the 'old' way of approaching this type of work. This works because it is comparing an aggregated mark (one little pane) against the entirety of the window. Unfortunately, this isn't possible with region. Fortunately, we have LOD calculations!