topic Re: Switching KPIs in diagramm with buttons in Integration, Extension & APIs

Switching KPIs in diagramm with buttons

dennisthemenace — Sat, 16 Nov 2024 01:03:46 GMT

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 — Tue, 24 Nov 2020 09:03:45 GMT

Try using a container.

dennisthemenace — Tue, 24 Nov 2020 09:50:53 GMT

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 — Tue, 24 Nov 2020 10:20:11 GMT

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

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