Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

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.