TIBCO Spotfire expressions : How to rename a group of nest columns into new names

Question

I have Bar chart with values colored by 2 different filters. What I need is to rename each combination of the 2 filters into just one name.

i tried to write it with CASE expression but with no luck.

below screenshot, shows what is required.

Any ideas ?

Screenshot sample : Motor Type

Answer 1

Why did you case expression not work?

Something like that should work:

<CASE [COLUMN] WHEN "VALUE1" then "Category A" WHEN "VALUE2" then "Category B" ELSE "Category C" END>

But in your situation I would do

<if([column 2] in ('SALA','SUPP'),'Motor category A','Motor category B')>

Add this expression here (right click > custom expression) :