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?