Custom Expression help

[Marcio Souza]

Hi There!

 

I'm struggling to understand an error message when trying to make a custom expression for Calculated Value. Here is the Calculated Expression:

CASE WHEN [name] = "${markedLiga}" THEN uniquecount([match_api_id]) over (All([league_id]))

ELSE uniquecount([match_api_id]) over (All([country_id]))

ENDUsing the "uniquecount([match_api_id]) over (All([league_id]))" alone in the Calculated Expression it will work, but it doesn't work when wrapped by the CASE WHEN above mentioned.

What I'm missing here I'm getting a "Please specify an aggregation method" error when clicking the OK button.

Regards,

Marcio

[Manoj Singh]

You need to specify an aggregation method before the case().

Refer to the documentation link:https://docs.tibco.com/pub/spotfire/7.0.0/doc/html/ncfe/ncfe_aggregations_in_expressions.htm

[Marcio Souza]

Thank you, Manoj Singh!