2 Replies Latest reply on Aug 3, 2016 6:36 AM by Ígor Marques

    Maps with regions and ranking filters

    Ígor Marques

      Hello!

       

      I have the following problem: I got some cities plotted in a map and they're colored according its region.

      I want to be able to display only a top 5 cities by its sales by each region.

      e.g.: show five cities from region 1, five cities from region 2 , etc. Not the top 5 cities of all regions.

      I've tried to use a calculated fild with "INDEX()" function but without success.

       

       

      Does someone know how to do?

       

       

      Thanks and regards.

      Ígor Chagas.

        • 1. Re: Maps with regions and ranking filters
          Carl Slifer

          Hi Igor!

           

          In this example we place [City] into the detail level of the marks card.

          Then we place SUM([Value]) onto text shelf of the marks card.

          Right Click that field and go to create table calculation and choose 'Rank', the compute using section should be changed to

          I went to Running Along and change this drop down to advanced

          Next and I made sure everything I wanted to group by was on the left and everything I wanted to run along or rank by was on the right.

          In my case I wanted to use state and country as these are levels of detail that matter to me ( I didn't want to group many several cities of the same name together).

          This should now rank for every city with respect to the region its in.

          Finally bring this calculated field onto the filters shelf and change the options to keep 'at most' 5.

           

          Cheers!

          Carl Slifer

          InterWorks

          1 of 1 people found this helpful
          • 2. Re: Maps with regions and ranking filters
            Ígor Marques

            Thank you!

             

            It's exactly what I was looking for.

             

            Ígor Chagas