Hi everyone,

I try to create two charts : a straight table + a radar that should display several KPI which I want to be able to select from a ListBox (if one is selected the charts should display it and hide it if not selected). Every KPI being calculated with a dedicated formula.

This is what I tried to do

• In the script, I have loaded my KPI expressions (KPI_Formula) and the KPI headers (KPI_Header) into a small table.
• I have created a straight table with KPI_Header as a dimension and  $(=KPI_Formula) as the expression.
• I have created a radar chart the same way

The problem I have is that the two charts show the result correctly only when 1 KPI is selected.

When I select more than one KPI in my ListBox it doesn't work as I intended and shows no results.

I have also tried differently in the straight table. I created one different expression for each KPI and set the Conditional show/hide according to the selection of the ListBox.

It works, but it is much less flexible that what I intended with the Headers and Formulas loaded in the script.

Also I can not do the Radar chart I want this way.

Does anyone know how I could make my charts display the results when more than one KPI is selected ???

Thanks!