I'm trying to modify a formula in my dashboard that currently uses multiple fields as filters inside an RSUM() aggregation. My goal is to apply OR logic across these fields rather than the default AN...
^ This, or even...
RSUM (
([# of unique INCIDENT_ID],[activity type]) +
([# of unique INCIDENT_ID],[activity type1]) +
([# of unique INCIDENT_ID],[activity type2]) +
etc...
)Although, this will double count INCIDENT_ID that meet multiple criteria. Maybe what you needs is...
RSUM (
SUM ( [INCIDENT_ID] ,
IF (
([# of unique INCIDENT_ID],[activity type]) +
([# of unique INCIDENT_ID],[activity type1]) +
([# of unique INCIDENT_ID],[activity type2]) +
etc... > 0
, 1 , 0
)
)
)