KPI value based on selection

[Anonymous]

Hi all

i have one table with 4 column: test, area, machine, type

how to set the expression of the KPI that show the percentage something like count(area or machine or type) *100/ count(test)?

Thanks.

[vikasmahajan]

Share Dummy data

[brunobertels]

Hi

In a KPI Object or Text Object the mesures would be like this

for area :

Count({$}area)/Count({$}test) select in the format number panel %

and same expression for area and machine

hope it helps

Bruno

[puttemans]

Hi, all depends on what you need, so an example would be more practical.

You'd get a percentage this way :

= (count(if(machine = 'yourdefinition', 1, 0))/ count(test))*100

Beware that you need to define the last part well. You need to make sure you get the right figure. In order to do so, I typically create several text objects, in which I put the first and the last part separately and the formula. That way, checking is easier.

Regards,

Johan

[VishalWaghole]

Can you please share dummy data.