WEIGHTED AVERAGE ON GRAPH CALCULATION

[valerio347]

Good morning, 

I have a question regarding the visualization of a formula on a line graph:

the need is to see a weekly trend  of a KPI performance measured in days on three plants. The Kpis measures the stock time of lots.

Since the formula is measuring with weighted average on kilos I have a problem in visualize the single value of a week. 

Hereby the formula:

Sum(
Aggr({<NOM_SITE={'NAP'}>}
Sum((AGRO_DATE_RECEPTION-AGRO_DATE_RECOLTE))
*
Sum(QTE_MOUVEMENT)
/
Sum(TOTAL QTE_MOUVEMENT)
, NOM_SITE, LOT_NO
)
)

As you can see we are calculating a difference of two hours * lot quantity. So the calculation is averaged.

The output on the graph is like this:

The problem is that the system is averaging the Kpi on the span of time selected (from week 27/2018 to week 2019/01) and not on the single week. To get to know the exact output of the KPI for a single week, I need to select the week one by one and write it down on a paper.

My question is: how can I change the formula in order to see the single weighted-average KPI on every week on the line graph? What formula should I try to use?

Many thanks in advance for your help

Regards

Valerio

[valerio347]

Hi all,

any news?