Recently I’ve been working with more data of my favourite kind - geospatial. I realised that this portion of Looker hasn’t been given the amount of love it deserves and thought of combining my feedback in this post, as well as sending it to Pendo, hopefully enriched by other people’s feedback and ideas as well.
It might be a long post but I think it’s worth it I’ll try to break it down.
When I have to refresh the whole page, to populate new fields for example, I can see different options for some time:
Before it settles:
Let me know if you have more items to put in the wishlist : )
I totally agree on your points, especially: it must be possible to use multiple measures and not just one.
@michael is it possible to allow the author to EDIT the initial post without time constraints? I wanted to add something but realised that we can’t edit our posts after certain time has elapsed.
Just so that I don’t foget:
When I have to refresh the whole page, to populate new fields for example, I can see different options for some time:
Before it settles:
Another thing is working with slightly bigger local files. I’m working with ~13MB and the problem is that after the upload, the file is being opened by default. This is good behaviour when you create model or view files but not data files.
Hey @Dawid, thanks for the ping about no time restrictions on editing past! There are some reasons we keep editing time boxed (largely because of how we pull data from the community). I’ll look into this a bit more and see what I can do.
Re: feedback around maps. Thank you for consolidating there - I definitely agree there’s a lot of opportunity in this area! I know this is something Looker product team agrees with too.
Consolidating your feedback and passing that through via Pendo is exactly the right move. Like all product ideas, the more business value you can tie to your request the higher the leverage. Not to mention that by putting your ideas in Pendo, you can track what’s actually going on with the request!
Another gem found today. Be aware of editing map files in Looker. There is some kind of cache going on there and the changes might not be detected even with your browser cache cleared and CTRL+F5.
I uploaded a file that didn’t work. The maponly showed up with Static Map (Regions) and was flipped. I realised that I had to change the Coordinate Reference System to EPSG:4326 (WGS84), the so calld Web Pseudo Mercator projection that is used in OpenStreetsMap, which is in Looker.
I reconverted the file but only copied and pasted the contents to existing file in Looker UI. I refreshed and refreshed, no change. Then, while also wasting support’s time I discovered I had to upload the file again and then it worked.
Maybe a bit polluting this topic, but has anyone implemented h3 cells to Looker as custom viz?
So that heatmap calculation is done on the frontend but not for rectangular shape but for the hexagon and you could adjust zoom levels?
Something like this:
Great topic @er1k! I thought about it a little bit. H3 JS could definitely allow us to do that. Convert the data points we have into hexagons in relation to the chosen zoom and then add a map layer on top of the usual map.
Sounds doable and it would be a cracking project to be honest..
Just adding my thoughts to this megathread, as I am seriously underwhelmed by Google’s lack of development for maps. I used these features a ton in Tableau which is highly customizable, but my company moved to Snowflake and Looker, and I’m now blindsided by the lack of creativity in Looker.
How can I get tooltips enabled on my maps? I have a list of users and their location_country mapped out, but when I hover over the visualization as I would anywhere else in Looker, I get no Tooltip.
Is there the option to change the color scheme of my maps? I’m only seeing the Red to Green scale--but thinking I would just like a light blue to dark blue scheme. Any options there?
Doesn’t seem like I can change the color of the items in the legend on the map… the default colors are the worst. This feature is available in any other visualization… why not here?
The GPS points on my map are hollow circles… visually this makes the map hard to read. I need solid dots.
Why doesn’t the legend allow me to click on/off the items in the maps like all other visualizations in Looker?
Another interesting thing I discovered was the fact that if the connection with the map is using a textual name, which of course makes sense as end users can’t operate on IDs that mean nothing to them, we can have a problem if there are two areas of the same name.
For example, in Spain there are two municipalities of El Molar, in Catalunya, and other in Comunidad de Madrid. I can’t make the map join by id because then users would have to use ID to display data on a map. But I can’t make the name unique either.. Therefore the polygon on the map will be combined and data treated as one
Sometimes it’s not possible to save changes if you simply change the file extension from *.json to *.topojson even though it’s still just JSON.
Suddenly I started receiving:
Can't read map layer file "file.json" from project "...".
But the file is still there, weird..