We'll have a look.

Hi,

Global value (%) is weighted average.
The weight is the value of the "importance".
So if all values are zero, weighted average is zero.

Hi

thank you for your answer, here are my comments

We understand well how the calculation is made, our question is more about the results that are displayed seem inconsistent with what we find in the database

So referring to the data in report/kpiDeliverable.php, we understand that the values of the tables kpiHistory and kpiValue are used.

However, these values do not seem to be in harmony

kpivalue

 

According to our calculations, the value in the database is good è 73% advancement

Our Internal Dashboard that calculates the same thing by compiling the table of deliverables :

kpihistory
gives us no results

If we look at another project: 4828
Values are incomplete and incorrect  :

The value of our dashboard and the kpiValue table are good « 96% » :

kpiHistory

So it seems that the assembly of the summary table by weeks in the report does not show the right values, although they are compiled correctly in the database.

Hi,

The difference you mote mayu come from the point that the report always takes the latest value of the Kpi for a period, and not the average of all walues.

Thanks for your answer. Unfortunately, we are not averaging while doing our calculation. We have tested on a fresh install v 9.4.3. with 2 deliverables of same weight (high) : first one at 100% (completed/accepted without reservations) and the other one not done (0%).

Our understanding of the formulas is :
SUM( status(%) * weight) / SUM(weight)
So, with our example (high weight = 1 – by default) :

((100% *1) + (0% * 1)) / (1 +1) = 50% KPI
1 / 2 = 50% KPI

KPI does not seem to reflect our previous result (50%) in the table (0%) neither is the graph (near 65%)

Our question is the following:
Is our understanding of the formula and the report values wrong?

In fact formula is not exactly what you write.
It is :
SUM( status(%) * weight) / SUM(max weight)
Where in fact SUM(max weight) is [number of item] x [max weight value avalable in weight table]

Thanks for the clarification for the formula.What about our last post screenshots: The formula gives a different value in the table view vs the graph with a fresh install of ProjeQtOr.Why do the graph view gives us about 65% and the table view 0% for the same week ?