9 Replies Latest reply on Jun 22, 2012 2:20 PM by Richard Leeke

    Switching between multiple datasets on one map

    Alex Lea

      Afternoon

       

      Apologies if this is a simple query or has been asked elsewhere.

       

      I have a dashboard with two polygon maps linked together so when one area is selected, it highlights the corresponding area on the other map for comparison and vice versa. One map shows the key dataset, and I want the other map to display three contextual datasets for comparison, that the user can ideally switch between. The problem is that I can't seem to find a way to switch between the different datasets, even though they are all in the same extract.

       

      I can map one dimension, but can't add the others and have a filter that can be used to select the different criteria. I've reshaped the data into a long table and even changed the different criteria into numeric values but it doesn't seem to work.

       

      In short, can it be done and if so, how? I've included a screendump below and have attached the data I'm trying to add.

       

      Regards

       

      Alex