This page lists the statistical fields that can be calculated and retrieved using the aggregate reports. Specify one or more of these fields when initialising your report dataset using Data API's /reports/datasets endpoints.

## Aggregate fields

These fields can be calculated for every group in the aggregate report.

Key | Description |
---|---|

`"population"` |
The count of users in all child groups of this group (eg. count of users in the region). |

`"lowest_score"` |
Minimum score for users in this population. |

`"highest_score"` |
Maximum score for users in this population. |

`"mean_seen_activities"` |
Average count of the specified activities for which the users in this population have at least one session. |

`"mean_attempted_percent"` |
Percentage of the seen_score attempted by each user across the filtered activities, averaged across all users in the population. |

`"mean_score"` |
Average score for users in this population. |

`"median_score"` |
Median score for users in this population. |

pNN_score (eg. `"p25_score"` ) |
Calculates the NNth percentile score for users in this population. Any two-digit percentile can be specified in the field name. The leading 0 is required for percentiles < 10. For example: `"p05_score"` : 5th percentile score.`"p25_score"` : 25th percentile score.
The 25th percentile score is the score cutoff at which 25% of scores in the population are below that value. See https://en.wikipedia.org/wiki/Percentile. |

`"stddev_score"` |
Standard deviation of scores for users in this population. |

`"lowest_percent"` |
Minimum percentage score for users in this population |

`"highest_percent"` |
Maximum percentage score for users in this population |

`"mean_percent"` |
Average percentage score for users in this population. |

`"median_percent"` |
Median percentage score for users in this population. |

pNN_percent (eg. `"p25_percent"` ) |
Calculates the NNth percentile percentage score for users in this population. Any two-digit percentile can be specified in the field name. The leading 0 is required for percentiles < 10. For example: `"p05_percent"` : 5th percentile score.`"p25_percent"` : 25th percentile score.
The 25th percentile percentage score is the percentage score cutoff at which 25% of percentage scores in the population are below that value. See https://en.wikipedia.org/wiki/Percentile. |

`"stddev_percent"` |
Standard deviation of percentage scores for users in this population. |

`"group_count"` |
The count of immediate child groups in this group (eg. count of schools in the region). |

## User fields

These fields can be retrieved for individual users in the leaf groups of the report, provided that the leaf group contains no more than 1000 users.

Key | Description |
---|---|

`"score"` |
Sum of the scores attained for this user’s seen activity set. |

`"attempted_max_score"` |
Sum of maximum possible scores on the attempted items in this user’s seen activity set. |

`"unscored_max_score"` |
Sum of maximum possible scores for attempted items in this user’s seen activity set which still require manual scoring. |

`"max_score"` |
Sum of maximum possible scores for this user’s seen activity set. |

`"seen_activities"` |
Count of the filtered activities for which this user has at least one recorded session. |