FIXED LODs are wonderful because they allow us to aggregate our measures at a chosen Dimension level, regardless of the level of detail of the worksheet. However, they aren't affected by Dimension Filters, because they're calculated before Dimension Filters are processed.

There are various scenarios where we need to work around that. We'll use Context Filters to help us where we need our LODs to be filtered, and we'll take a look at an example where you might not want your LOD to be filtered by your Dimension Filters.

Mar 13
Mar 13 How FIXED Tableau Level of Detail Function Works

Ollie Linley

Level of Detail, Table Calculations

FIXED Level of Detail Functions (LODs) let you specify the level of detail you want to aggregate a particular measure at. This allows us to work around the natural limitations of the level of detail in the worksheet we're working in.

FIXED LODs are a great place to start as they are the definitive, essential LOD. The two others (EXCLUDE and INCLUDE) are less common, but functional in their own unique ways. If you want to simplify and just learn one LOD type, FIXED is the one for you!

Nov 22
Nov 22 Filter to Keep Only Values with Multiple Records in Tableau

Eric Parker

Level of Detail, Tableau Calculations

Do you want to keep all data associated with a value which has multiple records in a data set? Maybe it's how many students attended multiple schools, how many patients visited a hospital multiple times or how many customers made multiple purchases.

Jun 10
Jun 10 How to Compare the Last Complete Week to the Previous Complete Week in Tableau

Eric Parker

Tableau Dates, Tableau Calculations, Level of Detail

I was recently working on a project where we wanted to compare weekly performance, but it only made sense to compare weeks once they were complete. As a result, we routinely came across situations where we wanted to compare the last full week to the previous full week.

May 1
May 1 Unraveling the Mystery of Tableau Level of Detail Expressions - Webinar Recording

Eric Parker

Tableau Calculations, Level of Detail

Level of Detail Expressions are one of the most powerful and least understood features in Tableau's calculation toolkit. Watch the below webinar recording to learn how they can be used to get more out of your Tableau workbooks.

Dec 26
Dec 26 Comparing Values to a Monthly Average (Across Several Years)

Eric Parker

Tableau Calculations

I was recently asked by a student how they could compare several years of monthly values to the monthly average over that time span. They had something like this in mind…

Dec 7
Dec 7 Can the same field be averaged and summed in a Tableau total?

Eric Parker

Tableau How-Tos

Totals in Tableau are notoriously rigid. You can’t add two totals lines; one for summarized values and one for averaged values, in the same worksheet. You can have one, the other, or allow Tableau to use a field’s default aggregation for totals.

Sep 28
Sep 28 When to use the EXCLUDE Function in Tableau

Eric Parker

Tableau How-Tos

Sep 7
Sep 7 How to Compare This Year to the Average of the Previous 3 Years in Tableau

Eric Parker

Tableau How-Tos

Here's an interesting challenges; how do you compare this year's values to the average of the previous 3 years in Tableau? The complex solution requires the use of the FIXED level of detail function. Watch the above video to follow along and learn how to perform this calculation.

May 25
May 25 Create a Percent of Total in Tableau That Isn't Affected by Filters

Eric Parker

Tableau How-Tos

As you likely know from using Table Calculations in Tableau, they only compute against the marks displayed in a worksheet. Check out this webinar in you need a refresher.

That means when a filter is applied to the worksheet, a table calculation will update to reflect only the data present in the worksheet.

Jun 9
Jun 9 Computing Header Totals in Tableau

Kirk Olson

Tableau How-Tos

I recently got an email from a former student explaining that they were trying to recreate something similar to the image below in Tableau.

The trouble she was running into was recreating the total header called “Planned Cost by Perf”. If you try to use a measure as a discrete header, you end up with the value summed for each partition. Here is an example using Superstore data:

Oct 30
Oct 30 Tableau FIXED LODs Not Filtering (Dimension and Context Filters)

Mar 13
Mar 13 How FIXED Tableau Level of Detail Function Works

Nov 22
Nov 22 Filter to Keep Only Values with Multiple Records in Tableau

Jun 10
Jun 10 How to Compare the Last Complete Week to the Previous Complete Week in Tableau

May 1
May 1 Unraveling the Mystery of Tableau Level of Detail Expressions - Webinar Recording

Dec 26
Dec 26 Comparing Values to a Monthly Average (Across Several Years)

Dec 7
Dec 7 Can the same field be averaged and summed in a Tableau total?

Sep 28
Sep 28 When to use the EXCLUDE Function in Tableau

Sep 7
Sep 7 How to Compare This Year to the Average of the Previous 3 Years in Tableau

May 25
May 25 Create a Percent of Total in Tableau That Isn't Affected by Filters

Jun 9
Jun 9 Computing Header Totals in Tableau

Youtube