2 Replies Latest reply on Jun 24, 2016 11:17 AM by Hildebrando Souza Jr

    Use Fixed LOD and Include simultaneously

    Alok Soni

      I am trying to create a visual where I want to show a fixed average for my order counts. That means if the users change the filter on the right for the week the total avg shouldnt change but the order counts will change based on the week.

       

      Attaching a screenshot from tableau however when i use Windows AVG to calculate the average the week filter changes the desired fixed average when the filter changes.

      WINDOW_AVG(AVG([Order Count]))

       

      2016-06-04_11-01-34.jpgAny suggestion are welcome.