Limiting a GeoAnalytics Line Layer

[jheasley]

I am trying to show a line layer with ONLY the top X(25 or 50, not sure yet) lines by Cost.  The limitation feature does not work, since i am using the First and Second measures to define the start and end of the line, with my 3rd measure indicating the Cost.  how can i create this limitation on my map?

[Patric_Nordstrom · Accepted solution]

Hi Joe,

To do that you need a calculated dimension, like this

=aggr(Only({<Statecode = {"=Rank(Sum(Trails)) <=10"}>}Statecode), Statecode)

Or place the set analysis expression in all expressions in the layer.

For a longer discussion:

Top X in Geo Analytics Layers

The new map chart in Sense have custom sort order, so it's possible to sort by sum(cost) descending and limit the layer to 25 objects. Line layer in new Sense map chart will be released in June.

Thanks,

Patric

[jheasley]

Thanks! That worked perfectly