3 Replies Latest reply on Sep 24, 2017 3:31 PM by Neil Lord

Guidance with creating map view of Top/Bottom N.

Hey,

I'm looking for ideal way to create a map view that has build in top/bottom parameter.  I'm making extensive use of parameters in this view and the map itself colors based on a parameter that calls different calculations.

• The top/bottom should be based on Parameter 'KPI Switch'
• It should be based on Highest/Lowest percentage of the KPI output.
• It's important that 'Vendor Manager Calc' is applied to the ranking of' KPI Switch' to develop the rank of each MSA based on the KPI results
• I have added 'Vendor Manager Calc' to context.

I have a similar set up working fine within a chart where its doing a table calc to rank each MSA top to bottom, but cannot figure out the best strategy when using a map.

I'm unable to provide a workbook, so even just suggestions for methods to complete this would be helpful.

• 1. Re: Guidance with creating map view of Top/Bottom N.

Hi Mike, one immediate thought is to right click on your Map sheet tab, and choose Duplicate as Crosstab.  See how everything is playing together in a table, get the numbers in the table as they should be, then go back and apply this logic to your Map. Sometimes it is easier to see how to solve a problem when the numbers are laid out for you in tabular form.

Best,

Jennifer

• 2. Re: Guidance with creating map view of Top/Bottom N.

I'm thinking the table calc method isn't going to work with maps.   Here is the cross tab with index calc added.  I can rank and now filter Top N and Bottom N leaving out middle, but unable to get the map view to work.

• 3. Re: Guidance with creating map view of Top/Bottom N.

Hi Mike,

Here's a mock up of a way to achieve this sort.

I have created 2 parameters, one controls the Top/Bottom N and the other controls whether you wish to see the top or bottom (pretty standard set up).

Next a created a calculated field:

This will change if the sort is ascending or descending.

Last step is to create a set:

Add the set to the filters and you now have a switchable map!

I hope this helps!

Workbook is attached