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?
I typically use the round function, something like this:
- dimension: location
type: location
sql_latitude: ROUND(${latitude},1)
sql_longitude: ROUND(${longitude},1)
Doesn’t this change the actual location though?
Hey
That is true, it would be less accurate. I’ve made a note of the use case with our product team!
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.