4 Replies Latest reply on Oct 26, 2018 7:23 AM by Rob Palmer

    Problem with filters

    Agustin Leira

      Hi everybody!


      I am doing a dashboard to manage Agencies with drop off and picked up.


      I have this data:


      Agency IDDate drop offDate picked upHourly RangeQ of shipmentsNº of picked up
      125/1025/109-12 hs1031
      125/1025/1015-18 hs 1402
      126/1026/109-12 hs1201


      I want to exclude of my analysis the agencies with 2 or more picked up per day.


      In this case, I want to exclude the Agency Id 1, with date drop off = 25/10 because had picked up in two hourly ranges: '9-12 hs' and '15-18 hs'.


      I need to put a filter to exclude them


      How can I do this?