New User - Error with Map Report

Looker Q&A Looker Studio
1

I am (obviously) new to Looker.

Here’s what I have done -

Connected a Google Sheet data source

Created a calculated field in the data source called County/State. It is a geo field and is a concatenated formula of two text fields.

Used that calculated field as the Location.

Created anothe calculated field that concatenates three other text fields. I used this as the tooltip.

The map shows up fine, but I have two main problems -

  1. Not all rows are showing. I should have many bubbles in a county, but only 1 or 2 show up. The data is in the data source but isn’t showing on map.

  2. I’d like the tooltip to include line breaks between some fields. Zero clue how to do this.

Any help you’re willing to provide is appreciate. Assume I know nothing about Looked. Thank you.

2

let me do my best to help here:

  1. Is this an aggregation issue? In Looker Studio, changing the dimension will change the granularity of the data. So for example, if your dimension is US state, then you would get back 50 rows, but if your dimension was county, then you’d get back many many more rows. Try viewing this data in a table viz before putting it in a map to make sure you’re getting back the number of rows you expect.
  2. There’s no way to do line breaks in tooltips. You could try using another delimiter like a hyphen or pipe (-, |)