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

    LOD calculation for a filter

    nikhil.jog

      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

       

      LOD=

      {

      FIXED

      [State]

      :SUM([Profit])

      }

       

      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?