LinkedIn
Twitter
Hi there, I am relatively new to Looker Studio. I'm working with a table, in BigQuery, of metrics attached to some custom regions in Canada - there are 21 regions/rows, each with a few metrics (e.g. biodiversity score, water risk score, etc.) and a geometry attribute with the vertices of the polygon. I made this with the following ogr2ogr command:
ogr2ogr -f csv -dialect sqlite -sql "select AsGeoJSON(geometry) AS geom, * from dataset" dataset.csv dataset.shp
I can open this up in Looker Studio and at least visualise the polygons as lines, but I'm struggling to do any further data manipulation because it doesn't have a valid location dimension (Chart Setup -> Fields -> Location -> Add dimension).
From what I've read, it looks like Looker Studio can only handle feature data with known dimensions, e.g. country, city, census tract. Is there no way to handle custom regions with this? I've also tried uploading my polygons as a separate dataset and then attaching the metrics to point data within the polygons, but the location dimension doesn't like the points either.
Happy to elaborate if the problem is not clear here, perhaps I'm missing something simple.
