CASE WHEN syntax w/ multiple conditions

Help and How-To

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?

bminehart

Posted 1 year ago·Last reply 1 year ago

6 comments

DRay

·1 year ago

Hi bminehart,

I wanted to check in with you to see if you still needed help with this. Can you let us know?

Thank you.

Garrett Wolfe

·1 year ago

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

DRay

·1 year ago

Hi bminehart,

I wanted to check in with you to see if you still needed help with this. Can you let us know?

Thank you.

Assaf Hanina

·1 year ago · Edited

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

bminehart

OP1 year ago

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?

Assaf Hanina

·1 year ago

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