Geolocation in Data Explorer - how to avoid mixed results?

[marc_zantingh]

When I base a graph or table in the Data Explorer on geolocation, the resulting data is on several different 'levels' - cities, countries, continents - all mixed up. Is there a way to prevent this, by filtering on one level for instance? 

[ChadTurner · Accepted solution]

You can set a filter to filter it by continent, but not list it by continents. The Ascending/Descending isn't by location name either, its based off the values for each location.  

This would be a great RFE to put in tho.

[zietho]

Chad is right.

You can, however, influence the sorting. To do so use the code mode like: 

before

after (using dimension instead of value): 

regards 

Thomas

[Julius_Loman]

@zietho I disagree on this. This will sort on the internal dimension value, not on the human readable value, so it's not applicable in general.
So it sorts on the values like APPLICATION-CB0200BF7867BEA0 instead of "Easytravel Angular". You need to engage the :names transformation to get another dimension value - the human readable one.

[zietho]

true indeed, forgot about :names ;). good catch and I will update by time.