CASE WHEN syntax w/ multiple conditions
We're trying to build a formula using CASE WHEN syntax with multiple conditions using AND. Example: CASE WHEN MIN(MNDIFF([time A], [time B])) <= 30 AND [column A]='Value' THEN DUPCOUNT([column B]) ...
Forum Discussion
Hey bminehart ,
in case it's on a widget level, the Syntax seems to be OK, however, it's seems the Case when is apply on string, [column A]='Value', if that's the case, than it's not supported on the dashboard level. |
Please find an example Syntax
Best Regards
Thanks AssafHanina.
We're trying to apply the formula at the widget level and it is not working. I'll get a snippet of the complete function and error to share here.
Also: you say it's "not supported on the dashboard level" -- I don't understand how CASE WHEN logic can be used at the Dashboard layer? It's syntax used in a function, and aren't functions only a feature within widgets?
Hey bminehart ,
Sure please share the Snippet of the widget formula.
Meant that using CASE WHEN statements on string fields is not supported in widget formulas at the dashboard level, although it is supported within the data model.
Best regards
