Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Primary/Secondary Filters

Avatar

Level 2

5/25/18

I would like to see a way to set a primary group of filters and then a secondary group of filters.

We use some complicated reports with 4 or more "OR" statements. Any time you set up an "OR" it often requires you to repeat the same fields/settings that you have in your other statements. It would be great if we could have a primary set of filters to limit the info we are looking at and then secondary filters to get into the nitty-gritty.

This would be similar to using a Stored Procedure in SQL where the Stored Procedure goes and gathers your base set of data, then you create a report from that and further filter/refine your dataset.

You could also think of this like a prompt. When you set up a prompt you are filtering your data BEFORE the report filters kick in. BUT, it requires a button click in your dashboard.

EX: I only want to look at issues for the last 60 days. But I also have 4 other filters I need to apply that would require "OR" statements.