Post

5 followers Follow
0
Avatar

Advanced Logic Filter

Creating new reports. Need an OR filter.

 I have been looking everywhere for a single example of the advanced logic syntax. Cant find a single thing. 

 

I have found this article: 
https://success.clarizen.com/hc/en-us/articles/206448037-13-3-Creating-a-new-report#creating-a-new-report

but it does not show any syntax. it just shows how to activate the advanced filter.

I just need to know how to reference a field? where is the help documentation on this syntax?

 

Denis

Denis Doiron Answered

Please sign in to leave a comment.

6 comments

1
Avatar

Denis,

What is it you are trying to do, I think you might be misunderstanding the Advanced Logic function from what you've said in your post.

The Advanced logic allows the ability to apply the filters in a specific way.  The standard (with nothing set) would be for all filters to be required, so in your filters 1 and 2 both need to be met for data to be included. The advanced logic can be used to set the filters as 1 or 2 meaning that an entirely different set of data is included in your report (all entries reported by you regardless of date and also all entries from everyone reported this month)

You mention you want to reference a field, what are you trying to do and I will help if I can.

Phil

Phil Smith 1 vote
Comment actions Permalink
0
Avatar

Ahhhhhh! Got it! The syntax is literally (1 and 2) or (3 and 4) !!!

 

Thanks so much!

Denis Doiron 0 votes
Comment actions Permalink
0
Avatar


So if I want filter only by milestones that include the word "round" and kick" how do I do that. I can get it to filter by one or the other, but cannot seem to get both to work. Thanks

John Brewer 0 votes
Comment actions Permalink
0
Avatar

Based on the image, they should already be filtering for round AND kick. Did you want round OR kick?

Josh Santos 0 votes
Comment actions Permalink
0
Avatar

In reply to John Brewer, advanced filter

1 and 2 and 3 and (4 or 5)

Derek Emous 0 votes
Comment actions Permalink
0
Avatar

Thanks! That is what I ended up doing the next morning when I revisited.

John Brewer 0 votes
Comment actions Permalink