I am trying to create a report with data filters that includes multiple instance of the same criteria. For example, the report needs to include two organizational groups (6137 and 6411). I've tried adding a filter for each group using both "is equal to" and "contains," but the report does not produce any results. How can I accomplish this?
Question
Question
Reports data filter - multiple instances of same criteria?
asked on April 12, 2018
0
0
Replies
replied on April 12, 2018
Hi Susan,
In order to include both criteria in your report, you'll want to use the "+Add another set of filters" button and then add that second Organizational Group constraint.
This will also include the instances that have the second number, therefore allowing you to report on both.
Basically, adding filters in one box (using the Add Filter button) will function like an "AND" search and only give back instances that meet both criteria. For example, if you wanted to report for instances where Organizational Group is 6411 and the start date was yesterday, you would add both of those in the same set of filters.
One final note, both the "is equal to" and "contains" operators will work; I just used contains for my test.
0
0
You are not allowed to follow up in this post.