All tagged LOD
Arrow charts make change visible at a glance by pairing a starting point with an endpoint connected by a directional arrow. They're ideal for showing before-and-after comparisons, tracking shifts over time, and communicating both magnitude and direction in a single mark, making them a powerful choice whenever movement is the story you need to tell.
Maybe the best part about them is that they're eye-catching and fun to look at! 🎨
When should you use Table Calculations and when should you use an LOD? There are differing opinions out there...
When the calculation is dependent on information in your window, use a Table Calc. When it's independent, use an LOD.
Unless... your workbook starts to show performance issues.
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.
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:
