Skip to Content

Weighted Average in Lumira

Dec 18, 2017 at 04:50 PM


avatar image
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.



average.png (10.0 kB)
10 |10000 characters needed characters left characters exceeded

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

* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Dec 19, 2017 at 10:10 AM

Hi Tammy,

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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