...
- Requirement A - Priority: High
- Requirement B - Priority: Low
- Requirement C - Priority: Medium
We could write a Faceted faceted aggregation expression:
Code Block | ||
---|---|---|
| ||
Faceted Equal(Priority, High) AS 'Urgent', OrArgs(Equal(Priority, Low), Equal(Priority, Medium)) AS 'Non-Urgent' { COUNT } WHERE EntityType = Requirement |
...
Code Block | ||
---|---|---|
| ||
Faceted Equal(Priority,High) as 'Urgent', Unmatched() as 'Non-Urgent' { COUNT } WHERE EntityType = Requirement |
In this case, anything that doesn't match urgent will be "unmatched" and fall through to the "Unmatched()" facet.