Manoj Chaurasia Posted July 3, 2014 Share Posted July 3, 2014 I would like to have some advice of using Weighted Average in custom expression and how to use OVER Goal is to have WA calculation based on several columns (Name, Activity type, Age, etc) and calculation will also cope with different filters applied in Visualization. How to proper make up the expression Why not include WeightedAverage into Aggregation list... Link to comment Share on other sites More sharing options...
Natalia Sojka Posted October 23, 2015 Share Posted October 23, 2015 Hi Dong, there is WeightedAverage([column1],[column2]) accessible through Edit Expression, or custom expression. If you use this expression on the y axis / value axis directly in the visualisation and then drop the categories which interest you on the x axis (you can drop several categories) then you should have the desired outcome. Let me know if that helps. Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted October 23, 2015 Author Share Posted October 23, 2015 Moving average incl. weights can be calculated via the LastPeriods-OVER expression. You can use a document property to specify the size of the moving average window. See the attached video for a simple example. Link to comment Share on other sites More sharing options...
Marijn Bax Posted February 28, 2020 Share Posted February 28, 2020 I'm facing a similar issue where I'm trying to calculate the weighted average of a Margin Percentage of a Certain Product within a quarter. please see my attached spreadsheet for more details. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now