Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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:
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
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:
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
Thanks! That worked perfectly