1 Reply Latest reply on Sep 9, 2016 10:53 AM by Patrick A Van Der Hyde

    Fixed LOD based on Parameter

    Vincent Baumel

      When I was first learning Tableau, I found LOD calculations tricky to understand. I was curious the other day about whether or not I could set the conditions of an LOD expression to a parameter that the user selects. I found a simple way to achieve this, and wanted to share it with anyone who may be struggling to wrap their head around how exactly these things work. Using the Superstore dataset, I wanted to allow the user to set the sales aggregation level based on location granularity. Maybe it can help someone out there who is struggling like I was. Here's an easy way to see what's happening!

       

      https://public.tableau.com/static/images/Fi/FixedLODExplanation/Dashboard1/1.png