1 of 1 people found this helpful
What you want is an ad-hoc group. This allows you to group the points of interest in the way you want.
Selecting the points spatially off a map and generating the group that you want is a little bit convoluted (I think - others may point out an easier way - as always I'm sure there are lots of ways to do this).
It's easiest to explain with an example - so I've attached a Superstore Sales workbook.
1) On sheet1 I've selected a few clusters of customers (hold down ctrl while you select) and created a set called Selected.
2) On sheet2 I've added the Selected set as a filter and also put Customer Zip Code on the rows shelf.
Select all zip codes, and then hit the group (paperclip) icon on the toolbar:
3) That will create a group containing all the members of the Selected set (and replace the Customer Zip Code dimension on rows, with the newly vreated group):
Right click on the group name in the data window (highlighted) and choose edit. That will display the current gorup members, which will be an individual entry for each of the non-selected rows plus one entry for the group of all selected ones.
Scroll down the list until you find the entry for the selected group, right-click it and rename it to "Selected".
Then select all the other entries and hit the Group button. Name this lot "Not Selected".
4) Finally, create a new sheet, put customer Zip Code on Level of Detail and Customer Zip Code (group) on the color shelf.
Can anyone think of a shorter route? It feels to me as if there probably is one.
It took me this long to get back to this because I had moved onto other things, but I ran into the same problem again, and your solution worked like a charm! It certainly is not something that I EVER would have found on my own so it is great to have this forum to turn to when I get completely stumped.
Ok, now I am trying to take things further by selecting a number of separate areas on a map and assigning a different code to each area selected so that I can color them differently on other graphs. The above methodology works great when I only have 2 areas (ie 'selected' and 'non selected') but I can't use it if I have to work with multiple regions. Any ideas?
The group approach should work fine with multiple groups, but I do recall that it can be a bit tricky to select multiple groups like that by selection from the map. It can be done though. I'll dig out the example workbook and put together a few more screenshots leading you through the process when I get a moment...
No time for screenshots, but here's a brief description of what you have to do plus an extended version of the example I posted before.
Basically you follow the same process as before, with a few modifications.
In step 1, you need to select each collection of marks that you want in turn, creating several sets.
Then repeat steps 2 and 3 for each set in turn (i.e. replacing the set on the filters shelf with each set in turn, repeatedly hitting the group paper-clip. Note that you mustn't create the final group of all the remaining ones until the very end.
Note that I had to create an extract because I got a "query too complex" error from the "Jet engine" which handles Excel files.
Message was edited by: Richard Leeke Replaced image which the forums had lost.
Grouping Data on Map v2.twbx.zip 529.2 KB
You know, I always come back to this post because I keep forgetting how to do this - thanks a lot for your answer. Really, we should be able to make this more intuitive in the future. I can't be the only one who keeps needing to do this....