# Filtering in Google Data Studio / Looker Studio

**URL:** https://community.piwik.pro/t/filtering-in-google-data-studio-looker-studio/1839
**Category:** Reports and working with data
**Created:** [March 16, 2023, 1:01pm UTC](https://community.piwik.pro/t/filtering-in-google-data-studio-looker-studio/1839 "2023-03-16T13:01:19Z")
**Posts on this page:** 1
**Showing post:** 5

<div class="post-metadata">

### Author: ![Thomas\_Anode\_FR](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/thomas_anode_fr/32/1425_2.png) [@Thomas\_Anode\_FR](https://community.piwik.pro/u/Thomas_Anode_FR)
#### Post date: [March 17, 2023, 8:30am UTC](https://community.piwik.pro/t/filtering-in-google-data-studio-looker-studio/1839/5 "2023-03-17T08:30:02Z")

</div>

Hello!

Great to hear that a fix is coming soon. 🙂

I wanted to have a table that shows the click rate (clicks / sessions) on specific custom events, based on their category. However, as it is not possible at the moment to prefilter a custom metric in Piwik PRO (I don’t know if it’s in your roadmap, but it would be nice 🙂), I chose to create this table via Looker Studio. For this, I created a blend with:

- For the first table: all sessions
- For the second table: custom events with a filter to only show the ones with the desired category

It worked well, and for whatever reason, I tried to add filters using this blend too. That’s when I saw it worked!

EDIT  
I just saw this post asking about filtered calculated metrics : [Using a filter in a Calculated Metrics - #2 by Jarek](https://community.piwik.pro/t/using-a-filter-in-a-calculated-metrics/630/2)

---

_[View the full topic](https://community.piwik.pro/t/filtering-in-google-data-studio-looker-studio/1839)._