Jump to content

How to add weighted average to a set of data

Abubakar anwar

Recommended Posts

Hi All,

coming back with another question.

I have set of rows which are aggregated at the lowest possible level at regions.

Two factors comparing against each other I have calculated if my organization is better on certain regional level than my competition. which works

the data has been assigned values based on GDP and are ranked in terms of percentage. For example a lane from AT to China weights less than DE to China.

If I do some changes in the amount of business I have on certain lane (DE-CN, decrease) it should have a bigger impact on my competitive position compared to if I change things on AT-CH lane.

Now I want to add a dynamic filter/column based on the rankings, if I change something in terms of business on DE to CN, it has an overall greater impact than AT to CN.

Is there a way to do this?

it is very complicated but any help will be highly appreciated.


Link to comment
Share on other sites

WeightedAverage([column1],[column2]) is 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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...