Unlike advanced BI tool like Power BI, Looker Studio only allows us to include single metrics to show on the tooltip when user hover on the map. In this tutorial, I’d be sharing simple workaround to “add” more than 1 field to Google Maps tooltip annotation. In my previous article, we’ve talked about how you can create a simple bubble map with geo coordinates: latitude and longitude.
If you have read that article, you’ve probably aware of the limitation in Google Maps, where the tooltip can only display a single dimension field. In this tutorial, I’d be sharing simple workaround to
add more than 1 field to Google Maps tooltip annotation.
Customized tooltip in Google Map Data Studio.
So this is a sneak peek into what we’ll produce today. This is actually a dashboard that shows all my favourite restaurant.
You can see when we hover on the map, it shows us the information like
restaurant name and
addresses, etc. whereas previously we can only a add single field which is the
restaurant name as the tooltip.
This would take less than 5 minutes to do!
In retail industry, we can use Google Maps, or to be exact Bubble Map to visualise and compare outlet performance in multiple regions. When users hover on the bubble, extra information helps management make an informed decision on business strategy. These may includes:
- outlet manager’s name,
- last month’s sales figures,
- growth rate,
- the location - whether it’s inside a shopping mall or shoplot,etc.
However, I’m well aware that adding manual label to tooltip may not be the best solution, especially when the text data becomes lengthy as we add more information.
So please do note that this is not the ONLY solution, I’m here to share the workaround I used to make the most out of Data Studio Maps.
It’s expected that you already know how to create a simple bubble map in Data Studio. If you’re in doubt, you may check out the below video tutorial.
In this video, you’ll learn basics about Bubble Map, such as how to create bubble map in Data Studio using geo coordinates,how to interact with maps, limitations, etc.
Adding multiple dimensions as tooltip annotations in Data Studio / Looker Studio is very simple. It would take you less than 5 min with just a simple calculated field!
Follow the steps below.
Step 1: Create Calculated Field with CONCAT() function
First, we are going to create a calculated field using
Add a Field and enter
CONCAT() function; Inside the parenthesis, add the label for the first dimension you wish to show.
CONCAT ("Field 1 Label: ", Field1)
Let say I want to show label for restaurant name, then I should type
- Remember to wrap the
- Usually I like to add
spaceafter colon to make it looks neat.
Next, we’ll add a dimension field
Shop Name to the
Step 2: Add a Divider
Before we add the next field, we’ll add a divider to separate the information visually so it’s easier for your users to read.
Inside the parenthesis, insert a divider text after the dimension field. You can use emojis for this to make it more eye catching.
CONCAT ("Field 1 Label: ", Field1, " | " )
In my example above, I’m using
Pin (📍) emoji as the deliminiter.
Step 3: Add Second field to CONCAT() Function
The last step is actually to add the second field:
Address, just like how we do it earlier for the
CONCAT ("Field 1 Label: ", Field1, " | ", "Field 2 Label: ", Field2)
It’s optional to add field label. You would notice that I did not add any field label for
Address, as I think the pin emoji earlier can serve as a label for location, which in this case, addresses.
After you have add all the information you wish to see, let’s save the formula.
Step 4: Add Custom Tooltip Field
Now let’s drag-and-drop the calculated field to Tooltip field in Bubble Map Property Panel.
Then, switch to
view mode to view the final result.
Congratulations! Now you can view more than 1 information when you hover on the bubble.
If you managed to do this and follow through, Take a screenshot and tag me on my social media account. I’d love to see what you have come out with!
More Map Visualisation Tutorial in Looker Studio!
- Looker Studio: Zoom In to Selected Area in Google Maps
- Looker Studio: Bubble Map Tutorial & Embedding Map in Websites
If you’re interested to explore more about Looker Studio visualisation, feel free to follow my youtube channel and turn on the notification so that you’ll get notified when the video is up!