Multiple values in output when multiple conditions are valid

Hi All,

In my dashboard I have a calculated column with below definition:

case  
 when [audit_risk_flag]="Y" then 
      "Risk: Audit" 
 when [isense_transient_max_last_month]>100 then 
     "Risk: Transient" 
when [isense_event_count_last_month]>10 then 
     "Risk: Event Count" 
when ([isense_transient_max_last_month]>50) or ([isense_event_count_last_month]>5) then 
     "Warning"
else NULL
END

Requirement:

Suppose multiple conditions are Valid in the above expression, For example lets say when [audit_risk_flag]="Y" AND [isense_transient_max_last_month]>100 AND [isense_event_count_last_month]>10 then  "Risk: Audit, Transient, Event Count"

Is it possible to do this without writing multiple cases?
Or is there any other workaround for this?

Regards,
Prateek

(1) Answer

Login