2 Replies Latest reply: Mar 27, 2015 11:33 AM by Henrique Falcao RSS

    Top Clients on Sense Map

    Henrique Falcao

      Hello Comunity!

       

      I need a map on Sense, showing only the top 10 clients...

       

      Here is what I'm trying to do on map settings:

      Layer: Clients Geopoint

      Unchecked show null values

      Expression: if(aggr(rank(sum(SALES)),IDCLIENT) <=10, 1,'')

       

      This actually shows on the map all my clients, and give bubble size to the top 10, and a 'X' on the map to the other clients...

       

      The problem is that I just wanna show the top 10 on the map...

       

      Any idea?

       

      Thanks

      Henrique