Performance Analytics Score in Formula indicators for percentage calculation(%)

[Vasanth Pandia1]

Hi All,

We are calculating the percentage of published Knowledge Articles which are useful in formula Indicator.

The formula: [Number of Published Articles marked useful] / [Number of published articles] *24

The result i.e. the score after job run, always gives more than 100%, which is incorrect. Could you please let me know how do I overcome this?

Regards,

Vasanth

[Vasanth Pandia1]

Correction to the formula: dividing by 100 not 24.

[Vasanth Pandia1]

Correction: Multiplication by 100.

[Arnoud Kooi]

So the formula is:

[[Number of Published Articles marked useful]] / [[Number of published articles]] * 100

Maybe you should select count disctinct on number for the Number of Published Articles marked useful indicator.

(After changing this you need to re-collect the results)

If a single article is marked multiple times as helpful, you can get results higher then then, with just a count

Otherwise I would recommend analyzing the results, by drilling down in the scores tab of the detailed scores card.

And where result are strange, analyse and review your Indicator And Indicator source conditions.

[Vasanth Pandia1]

Hi Arnoud,

Yes, I already tried with the count distinct. it is working as expected.

Anyways thank you so much for your response.