How to conditional dimension in Radar Chart?

[#1]

The variable 'Values' is used as dimension, which has five values: A, B, C, D, E.

I like the chart to use A, B, C as dimensions. I enable 'conditional dimension' in the dialogue box and input

match(values, 'A', 'B', 'C')

However, the chart still shows all the dimension values. Any ideas on the solution? Thanks.

[Gysbert_Wassenaar]

The conditional dimension is for showing or hiding the entire dimension itself. It's not an expression to show or hide some dimension values. What you want is to use a calculated dimension. There you can use an expression like: =if(match(Values, 'A','B','C'), Values)

Is the name of the field 'values' or 'Values'? Field and variable names are case sensitive.

[Anonymous · Accepted solution]

Hi Dennis,

It is better to filter the vars on Expressions with Set Analysis:

COUNT({<Values = {'A','B','C'}>} DISTINCT ID)

Regards!

[#4]

Thanks for reply. The calculated dimension gives an additional dimension beyond A B C. I am not sure why this happens.

Manuel's solution works perfect! All I need is to replace count as sum.

Sum({<Values = {'A','B','C'}>} Score)

[#5]

Thanks, Manuel.

This works out perfect. All I need is to replace count as sum.

Sum({<Values = {'A','B','C'}>} Score)

[Anonymous]

Hi Dennis, I am glad that the solution is what you need.

Regards!