Pie Chart Constraint Expression

Hey everyone, I’m new to the development world (and no code) and have a very simple question (i’m sure). Can the constraint expressions include “AND” or “OR”? For example…

I’m creating a pie chart where I need for one of the sections to include two options in a list. My expression looks like this right now:

Search for Assets: Count
Constraints: Asset Cycle Count Status = Updated

I need for this constraint to include options Updated OR Validated.

Many thanks for your time!

Hi there,

The “Merged With” operator effectively combines 2 lists, and can be used in place of an ‘Or’. For your use-case, you would do:

Search for Assets
Constraints: Asset Cycle Count Status = Updated
Merged with:
Search for Assets
Constraints: Asset Cycle Count Status = Validated
:Count

Please note to only include ‘Count’ at the very end of the expression, so it counts the total from both lists merged together.