How are Breakdown Aggregations calculated?

[Chris W1]

Hi Everyone,

I have been working through the conversion of some manual reporting coworkers have been doing and ran into a new use case (for me) - showing the aggregated value of multiple breakdown elements instead of separate values. 

I have:

• created multiple formula indicators that calculate a percentage scores for various participation metrics, having replicated some excel formulas in the formulas. 
• Added widgets to a dashboard that leverage these formula indicators
• Added breakdowns to the indicators and to the dashboard

Users are then selected as a breakdown elements on the dashboard to see, depending on use cases either:

1. individual scores (elements shown separately) or
2. wrapped up scores across multiple users (elements aggregated)

However, I am finding that the aggregated value that the indicators are providing is not aligned with the expected outcome from the manual reports which is the mean average. (Aggregation is also not providing the median either)

EDIT: just to note that the automated indicators are collecting the expected data and the formulas work at a per-user level, the issue is only seen when aggregating, hence why I am trying to understand what/how the aggregation works.

Can anyone provide some background/context on what the expected mathematical outcome is when using an aggregation of multiple breakdown elements please?  Or perhaps I've made an error that I have overlooked?

[AndersBGS]

Hi @Chris W1 ,

Look at your automated indicators scoresheet. In here you can see which numbers is utilized under which breakdown. Basically, when you breakdown by e.g. specific assignment group or several assignment groups, then the automated indicators scoresheet will hold that data and then utilize the formula that you have created. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Chris W1]

Hi Anders, yeah, already did all that, the automated indicators have the correct data in their scoresheets and the formulas produce the correct data at per person (breakdown element) level the issue is ONLY when using the Aggregation option on the widget

[AndersBGS]

Hi @Chris W1 ,

Which aggregation option are you referring to? Can you share a snip?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Chris W1]

the aggregation option within a widget to show multiple elements as an aggregate, rather than seperately