Share via

How is the Azure Advisor aggregate score calculated for 2 or more subscriptions?

Van Vo Hai 100 Reputation points
2024-12-01T18:41:06.9533333+00:00

Hi supporters,

I would like to understand how Azure Advisor calculates aggregations for the five pillars across multiple subscriptions, as I need to visualize this data in my application

In the example below we have values for Azure Advisor subscription 1 – (Cost = 74, Security = 59, Reliability = 98, Operational Excellence = 90, Performance = 100) 

User's image

And subsequently values for Azure Advisor subscription 2 - 

(Cost = 100, Security = 59, Reliability = 100, Operational Excellence = 100, Performance = 0)User's image

When selecting both subscriptions, we obtain the aggregate values

User's image

I expected that the aggregate Advisor scores would be the arithmetic average between the two, such as Cost = (74+100)/2 = 87, but that is not the case. Could you please help with this?

Azure Advisor
Azure Advisor
An Azure personalized recommendation engine that helps users follow best practices to optimize Azure deployments.
70 questions
0 comments
Accepted answer
  1. Marcin Policht 30,040 Reputation points MVP
    2024-12-01T18:55:33.7366667+00:00

    Azure Advisor aggregates scores across multiple subscriptions by calculating a weighted average based on the number of resources or services contributing to each pillar within each subscription, rather than a simple arithmetic mean. This means the score for each pillar is influenced by the proportional contribution of resources from each subscription to the overall metric. For example, if Subscription 1 has significantly more resources impacting the "Cost" score compared to Subscription 2, its score will carry more weight in the aggregate calculation. This ensures the aggregate scores reflect the real-world impact of recommendations across all resources rather than treating subscriptions as equal regardless of their size or complexity.

    If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

    hth

    Marcin

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.