Spider Chart - Custom Values

[#1]

Dear community,

I have one question with the spider (radar) chart. I want to use the spider chart to represent 6 different values.

Those values will represent KPIs and are definied in "Dimensions" tab with the following statement:

ValueList('KPI','KPI2','KPI3','KPI4','KPI5','KPI6')

Now i want to add custom values in the "Expression" tab. How can I do this?

It should be like this:

ValueList(formula KPI1 e.g. sum(Revenues)/Amount of Orders,'KPI2','KPI3','KPI4','KPI5','KPI6')

Any Ideas?

[giakoum]

you would need the match function to match the valuelist to an actual field value in the dimensions expression. if you do that, expressions should work without anything special needed.

[maxgro · Accepted solution]

If I understand your question, your expression should be

if(ValueList('KPI','KPI2','KPI3','KPI4','KPI5','KPI6') = 'KP1',  sum(Amount),

if(ValueList('KPI','KPI2','KPI3','KPI4','KPI5','KPI6') = 'KP2',  sum(....),

...

...

...

if(ValueList('KPI','KPI2','KPI3','KPI4','KPI5','KPI6') = 'KP6',  sum(....)

))))))

[#4]

Thanks a lot, this was the right expression to solve my problem.

Now I have another question - it is possible to represent those calculated KPIs values in the chart?

I've added a sample file below - the black line represents the KPI values and the red line

represents the benchmark.

Thanks in advance!