The Tickbox control in Looker Studio is a box that can be checked or unchecked to enable or disable the filter for a specific value. The only requirement is that the dimension used must be boolean (true or false).
Visit the post on how to add controls to your report in Looker Studio, if you need a refresher.
For the examples in this post, I’ve used the Superstore Products dataset. Visit the post on how to add data sources to Looker Studio to learn more about it.
1. Example
I created a new field in my data source that returns true if the product name contains Wilson Jones and false if it doesn’t. I’ve named it Wilson Jones (you can see how to create it in the post about calculated fields -dimensions- in Looker Studio). To use it in the tickckbox control, I added it as the Control Field.
You can see how to create fields in the posts about custom metrics and dimensions, but if you want to create Wilson Jones to follow along with the examples, follow these steps:
- Go to Resource → Manage added data sources → Edit (on the right of your ‘Superstore Products’ data source) → Add a field → Add calculated field (found in the upper right corner).
- In the field name, write Wilson Jones, and in the formula, enter the following:
IF(REGEXP_CONTAINS(Product Name, ‘Wilson Jones’), True, False)- Click Save and your new field will be created.
In the tickbox configuration, choose the new boolean dimension Wilson Jones as the Control Field.
The control can be enabled or disabled by default. To do this, you need to enter true or false in the Default selection setting. I’m going to leave it blank, so the user can choose. In this case, the symbol will be a minus sign (-). If it were true, it would show a checkmark by default.
As always, questions and comments are more than welcome 🙂