# Use filters to exclude "No data"

**URL:** <https://community.piwik.pro/t/use-filters-to-exclude-no-data/2933>\
**Category:** Reports and working with data\
**Created:** [September 20, 2023, 10:46am UTC](https://community.piwik.pro/t/use-filters-to-exclude-no-data/2933 "2023-09-20T10:46:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dav](https://avatars.discourse-cdn.com/v4/letter/d/977dab/32.png) [@dav](https://community.piwik.pro/u/dav)\
**Post date:** [September 20, 2023, 10:46am UTC](https://community.piwik.pro/t/use-filters-to-exclude-no-data/2933/1 "2023-09-20T10:46:04Z")

</div>

I am combining the Pages report with a secondary custom dimension. The event dimension includes many “No data” events. I tried to use the quick filter “is not” and “does not contain” = “No data” but this does not remove these events.  
(Perhaps understandably, since these fields technically in the backend probably are empty in the Piwik database?)

Instead, I’ve resorted to regex so that only events with at least one letter are included:  
`.*[a-zA-Z]+.*`

So my question is whether there is a more intuitive, user-friendly way to exclude “No data” events, since not everyone knows regex.

And if there isn’t any way right now, I would request a feature to be able to filter for empty or “No data” fields, and/or that “is not = Not data” could work.

---

<div class="post-metadata">

**Author:** ![rmastop](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/rmastop/32/29_2.png) [@rmastop](https://community.piwik.pro/u/rmastop)\
**Post date:** [September 20, 2023, 10:51am UTC](https://community.piwik.pro/t/use-filters-to-exclude-no-data/2933/2 "2023-09-20T10:51:16Z")

</div>

Sure, setting a filter `is not` and keep the edit field empty does the job.

Let me know if it helps your case

Kind regards,  
Richard

---

<div class="post-metadata">

**Author:** ![dav](https://avatars.discourse-cdn.com/v4/letter/d/977dab/32.png) [@dav](https://community.piwik.pro/u/dav)\
**Post date:** [September 20, 2023, 11:02am UTC](https://community.piwik.pro/t/use-filters-to-exclude-no-data/2933/3 "2023-09-20T11:02:54Z")

</div>

Haha, brilliantly simple, of course! 🙂 Thank you!
