3 Replies Latest reply: May 13, 2016 7:07 AM by Gysbert Wassenaar RSS

    Filter by Ranges

    Chris Waterworth

      Hi All,

       


      I'd like to create a filter pane so I can break up my data by population size (peak tourism + resident population). I have tried using a pick(match) function to set the ranges but my formula isn't working and I'm a bit stuck. Any help would be appreciated.

       

      pick(

      (match(([Peak Tourist Pop]+[residentAndCommunalPop2016]),>'0'and<='100',>'100'and<='1000',>'1000'and<='10000'))

      '0-100',

      '100-1000',

      '1000-10000')

       

      Thank you