Radar Chart with dynamic dimensions (from alternate states)

[#1]

Hey guys,

I want a radar chart looking like the attached in this thread: Radar Chart

What´s energy, refresh and so on there is what I want to be a selection from a multibox with alternate states like here and its underlying calculations.

Could someone post an example?

Many thanks!

[#2]

Ok, so I am getting closer.

There are some details I could not fix:

1. The KPIs are not written out

2. I do not know how to plug in the Credit Analyst and Credit Manager dimension in the pick function so that I get two lines.

3. Can one display the values for each KPI in the graph? I only get them as Quickinfo...

swuehl‌

I thought this might be a nice visualization to show a few KPIs for different groups. Any other Idea?

[swuehl]

Maybe like this:

Create a calculated dimension

=ValueList('ROA','ROE','Economic Capital','Current Exposure','# of Customers')

Then the expressions look like

=Pick(Match( ValueList('ROA','ROE','Economic Capital','Current Exposure','# of Customers'), 'ROA','ROE','Economic Capital','Current Exposure','# of Customers'),

YourROAExpression,

YourROEExpression,

YourEconomicCapitalExpression,

YourCurrentExposureExpression,

YourNumberOfCustomersExpression

)

So if I understood you correctly, you will have two expressions like this and you create appropriate measure expressions (like YourROAExpression ) in each, one time for the values for the Credit Manager and then for the average of the chosen credit analysts.

[#4]

I have made it with a data island, see below.

Only thing causing trouble is that the KPIs are not written out on the axis.

It only shows Only({GroupR1} _Metric) instead of RoE for example...

I have read something about the concat function but I don´t get it going.

Would very much appreciate any help or hints 🙂

[#5]

I have also tried many variations of =$(Only({GroupR1} _Metric)) and so on but I do not get the result. What is my mistake? 😞

Another question:

When you have a metrics sheet like the attached can you compress the pick function?

For now I have got:

=pick(island, $(=Only({GroupR1} _MetricFormula_Peer)),$(=Only({GroupR2} _MetricFormula_Peer)),$(=Only({GroupR3} _MetricFormula_Peer)),$(=Only({GroupR4} _MetricFormula_Peer)),$(=Only({GroupR5} _MetricFormula_Peer)))

Can I somehow plug in a match function into the pick function so it always matches the right _MetricFormula to the _Metric which is basically the dimension?