Question - Filter “either one of 2, or both”

Forum - Software
#1

Hi
I’m needing a filter in the audit that says:
“Show me the controls that have audits AND maintenance this year”
When making that filter it shows me one sngle control that have both an audit and a maintenance this year.
But I want to see the 39 controls that have audit I 2020 and the 22 controls that have maintenance I 2020 in the same filter.

Somebody know how to “hack” this? :sunglasses:

Thanks

By using this forum you accept our rules (eramba forum rules - Google Docs) and privacy policy (https://www.eramba.org/privacy) !

#2

It seems that what you actually need then is an OR instead of an AND ? if that is the case, is not possible filter combinations are AND in between them … making that optional is really really complicated to do, at least now !

#3

Hmm. I also need to filter all audit dates from a specific period: Q3-Q4 2019. Is that the same issue? Not possible for the moment?
I can only find the “from” date and not “from and to date” in the filter . but mayby there is a triggy workaround ? :slight_smile:
thanks

#4

you need to filter against the “planned date” twice? from this plan date to that plan date?

1 Like