Simplifying my query with easy numbers. I want to plot the graph showing weighted average as shown in the image below in Lumira but aggregation allowed is only at a simple average level and not a weighted average. Moving average is also giving me simple average numbers.

Formula: Weighted Average = Sum(rate*qty)/Sum(qty)

Couldn't find this in the archive. I'm a new user so pardon my lack of understanding.

## Add comment