Multiple values in output when multiple conditions are valid
In my dashboard I have a calculated column with below definition:
when [audit_risk_flag]="Y" then
when [isense_transient_max_last_month]>100 then
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
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?