Has anyone worked out how to use AND / OR operators in reports?

I've been asked to create a report that identifies any tasks where key fields have been left blank.

e.g. (Manager OR Practice Lead are empty) AND (Status is Active).
I can easily create separate filters for each field - but is there any way to apply an OR operator between them?

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
1 comment

Hi Mat Ward,
for this type of report I moved to new dashboard with new filters (you can manage different groups of filters and add AND/OR operator).

For Wrike Analyze, it occurs to me that you could have two different widgets, one for Manager and one for Practice Lead, listing all available entries.
Below these two widgets is a table showing the tasks found.
When you enter the dashboard, click "empty" in the first widget one at a time to see the tasks without Managers, and then do the same for the other custom field.
It's not optimal, but it's a workaround.

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Has anyone worked out how to use AND / OR operators in reports?
[this list is visible for admins and agents only]

Top

Upcoming Live Sessions

Didn’t find what you were looking for? Write new post