CASE WHEN syntax w/ multiple conditions

Question

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]) ELSE 0

This syntax is not working. Any tips?

assafhanina · Answer

Hey&nbsp;bminehart&nbsp;,
in case it's on a widget level, the Syntax seems to be OK, however,&nbsp;it's seems the Case when is apply on string,&nbsp;[column A]='Value', if that's the case, than it's not supported on the dashboard level. |Please find an example Syntax

Best Regards

gwolfe · Answer

bminehart​ CASE statement on strings will work in the cube. We have pushed these calcs upstream to the cube or database level.&nbsp;

bminehart · Answer

Thanks&nbsp;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?

assafhanina · Answer

Hey&nbsp;bminehart&nbsp;,
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

dray · Answer

Hi&nbsp;bminehart,
I wanted to check in with you to see if you still needed help with this. Can you let us know?
Thank you.

Forum Discussion

CASE WHEN syntax w/ multiple conditions

Recent Discussions

New Filter Regression

Semantic Layer tables stack up like a deck of cards

Tabber widget management

Resizing Sisense's Interactive Pivot dropdown menu

How to configure SSO with JWT

Sisense

Support

Resources