Weighted Average in Lumira

[Former Member]

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.

Regards,

Sandiep

[TammyPowlas]

Which version of Lumira are you using? I am not sure it can do this. Also, what is your data source?

[Former Member]

Hi Tammy,

I'm currently using Lumira version 1.31.1 and my data source is SAP Business Warehouse.

[TammyPowlas]

Hi - I don't see how this can be accomplished, but maybe the community has some ideas....it is a good question and good idea