2 Replies Latest reply on Jul 6, 2018 4:50 AM by Jim Dehner

    Grouping UK local government districts into larger groups

    Farshad Rastgouy
    Farshad Rastgouy Jul 6, 2018 3:14 AM

      Hi,

       

      I'm making a viz that use UK local government districts and wish to display this on a map. The data also contains information on larger regions such as 'England', 'East Midlands' and 'Inner London'.  Problem is that some of the local government districts are so small you can barely see them.

       

      I want to group these local government districts into group and I actually know how to do this using the calculated field. All you have to do is write something like:

       

      IF  [Geography] == 'Enfield' THEN

      'London'

      END

       

      The problem is that there are hundreds of regions, so writing this out is laborious.

       

      Does anyone know an easier way of grouping these local government districts?