Expand my Community achievements bar.

Multiple aggregator functions?

Avatar

Level 3
Folks, Just curious if anyone knows whether it's possible to aggregate values depending on grouping (AVG for grouping 1 and MAX for grouping 2); the for the same column in one report? My use case is risk scores: I'd like to be able to get an item level report with 2 groupings: 1. Portfolio name and 2. Project Name, where the project risk score is just the MAX item risk score, while the portfolio risk score would be a AVG value of those same risk scores. Thank you, Andrey Andrey Popov JLL
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 4
Hi Andrey, No, you cannot have different aggregate functions at different grouping levels. You could add a field to the report twice and get different aggregate functions on the report. Daniel Daniel Cooley Kenall