Switching KPIs in diagramm with buttons

[dennisthemenace]

Hello everybody,

I got the requirement for Sense to implement a Diagramm / table showing different KPIs depending on the Button you press.

So, I guess I need to work with variables in the KPI like:

IF(vKPI = 'Sum' , Sum(revenue),

   IF(vKPI = 'Quote' , Sum(revenue)/number)

.. and the variable is set by the buttons.

Unfortunately, I didnt find a way to make it work.

Anybody who has got an idea?

Thanks!

[ErikWetterberg]

Try using a container.

[dennisthemenace]

I tried to use the container with show/hide, but can u give me a hint how to use a variable correcly in there?

In the container hide/show extension: if(vKPI='Plan', 1 , 0)

The button: vKPI with value ='Plan'

[dennisthemenace]

I have found a method now how to deal with it.

I am just using a variable with pick function in kpi.