2 Replies Latest reply: Mar 27, 2015 11:33 AM by Humberto Falcão RSS

    Top Clients on Sense Map

    Humberto Falcão

      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?