Value formatting for 'location' type dimensions

  • 21 April 2015
  • 4 replies

Userlevel 3

When I include a Lat/Long location, I’d like the result to only display a set number of decimal places.

Even though I can format the values in the Lat and Long dimension, I seem unable to get the combined “location” dimension to display any custom formatting when using the value_format flag.

Any tips on how to format a location dimension?

4 replies

Userlevel 1

I typically use the round function, something like this:

  - dimension: location

type: location

sql_latitude: ROUND(${latitude},1)

sql_longitude: ROUND(${longitude},1)

Userlevel 3

Hey @Mike_Ritchie,

That is true, it would be less accurate. I’ve made a note of the use case with our product team!

Doesn’t this change the actual location though?

Cool, I don’t think most people intuitively know how to interpret lat and lon anyway, so even replacing the actual data with just an icon that would allow them to click thru to the Google map (e.g. a map icon) would be cool