3 Replies Latest reply on Apr 13, 2018 2:42 PM by Joe Oppelt

    LOD calculation for a filter


      I have data like below


      Region State Profit

      west     az          5

      west     ca        10

      west     or          15

      east     ny          7

      east     nj           12

      east     ri           17 


      I am plotting profit by region


      so i have

      west 30

      east 36


      now i want to put a filter so that users can discard state's that had profit less that some threshold


      this is what i did

      created a calculated field









      then added a filter on LOD. When i was creating a filter on LOD, i clicked on "all values" and selected "range of values". My filter seems to be working as intended. If i adjust slider to begin at 6 then it is removing az from calculation.


      is this a correct way to add such filter?