topic Top Clients on Sense Map in App Development

Top Clients on Sense Map

hvfalcao — Fri, 27 Mar 2015 12:46:58 GMT

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 — Fri, 27 Mar 2015 14:28:32 GMT

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 — Fri, 27 Mar 2015 15:33:12 GMT

Jonathan,

Very helpful! Perfect...

Thank you