Top Clients on Sense Map

[hvfalcao]

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

[JonnyPoole · Accepted solution]

I think so...

What is did is  to also use the color by expression to customize the color of the point based on Top10

My color expression uses the 1st parameter of the arbg() function to establish 100% transparency for NON-top 10 cities

if( aggr(rank(sum(Sales)),City) <=10, argb(255,255,0,0),argb(0,125,125,125))

see if this helps.

[hvfalcao]

Jonathan,

Very helpful! Perfect...

Thank you