topic Re: Geolocation in Data Explorer - mixed results in Dashboarding

Geolocation in Data Explorer - how to avoid mixed results?

marc_zantingh — Tue, 30 May 2023 13:45:18 GMT

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?

Re: Geolocation in Data Explorer - mixed results

ChadTurner — Wed, 30 Mar 2022 15:47:57 GMT

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.

Re: Geolocation in Data Explorer - mixed results

zietho — Wed, 20 Jul 2022 21:45:55 GMT

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

Re: Geolocation in Data Explorer - mixed results

Julius_Loman — Thu, 21 Jul 2022 08:11:24 GMT

@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.

Re: Geolocation in Data Explorer - mixed results

zietho — Thu, 21 Jul 2022 13:15:00 GMT

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