Embedded Files
Building a Simple
readwhatyouwant.com/looker
This is a great starter project for dipping into Looker.
This is a great starter project for dipping into Looker.
If you manage a reading challenge in a library, it also may end up being a game changer for you.
If you manage a reading challenge in a library, it also may end up being a game changer for you.
We're going to Looker. It's not even scary!
We're going to Looker. It's not even scary!
https://lookerstudio.google.com/
Click Create and select Report.
Bring in the data
Bring in the data
When it asks what to connect with, select Google Sheets.
It will ask what data you want to add from Google Sheets, and since you just were in the sheet you copied above, "A Simple Reading Challenge (Responses)", you should see it near the top.
Select it and click Add.
It's about to get real. Look out.
It's about to get real. Look out.
Click on Add a Chart. Select Scorecard (Total).
Drag that scorecard onto your blank dashboard. It should default to the record count of however many entries our spreadsheet has.
Get to know your data source
Get to know your data source
While you still have that score card selected (it has a blue box around it) go to the setup column on the right.
Click on the pencil next to your data source, indicating you want to edit it.
All the magic in a few clicks.
All the magic in a few clicks.
It's this step where we filter by email. Not hard, but it's important if you want to make dashboards for kids or other users where they only see what they have entered from a much larger data set.
I'm going to let the pictures do the talking. You could figure it out without them, but just in case...
Please note that by enabling filter by email, everyone who encounters your dashboard will be asked to grant consent, as Google has to know your email for it to work.
This only pops up the first time they visit it.
Let's bring in
something else
Let's bring in
something else
Go back to Add a Chart, but instead of a scorecard, we'll do a table this time.
Drag/drop it onto your dashboard.
Add a Dimension
Add a Dimension
Click on the little plus sign by Add Dimension, and then select First Name as the field you want.
Don't freak out, but...
Don't freak out, but...
You should now have something pretty dang ugly and frankly disappointing in many ways. Certainly not ready to push out. But hear me out. You have a dashboard will essentially the same FUNCTION that I ran with my first year doing this. Everything else is aesthetics.
Everything else is aesthetics.
You've got this.
Quite possibly, the saddest Looker Studio ever. We just made this! But it's almost identical functionally to the one below circa 2021.
Page updated
Report abuse