2 Replies Latest reply on Mar 23, 2017 11:50 PM by Matthias Stede

    How to performe fixed LOD with date field and dimension filter

    Matthias Stede

      Hello Tableau experts,

       

      I'm trying to build a view where I want to get the sum of sales for every day in my database and want to compare this sum for every day with the sum based on a dimension filter based on customer name for all days in my database.

      I use {fixed [Order Date]:sum([Sales])} as LOD to show sales for every day indipendent from my Dimension filter.

      How ever my result looks like this:

      Order Date LOD.PNG

       

      Isn't it possible to get all Sales for every date with this LOD? My understanding was, that LODs will be performed before the Dimension filter.

      I attached my workbook as well.

       

      Thanks in advance,

      Matthias