Enhanced Grid Widget Aggregates & Custom Calculations
product review
Ben Walter
We are requesting support for custom aggregate calculations. A specific example provided is an aggregate function that removes the maximum and minimum values in a column and calculates the average of the remaining data. This feature would allow users to address scenarios where outliers significantly impact results.
Log In
J
Joyce
Hi Ben,
Thank you for sharing this excellent suggestion! While we can’t provide a specific timeline at this moment, we’re actively tracking interest and gathering additional insights to confirm the demand of this requirement.
This post will remain open for ongoing discussion, and we’ll share updates as progress unfolds. Your contributions play a critical role in shaping our priorities, so please don’t hesitate to share further ideas or use cases in the comments.
We deeply appreciate your patience and partnership as we work to deliver meaningful improvements. If you have any questions or need clarification, feel free to reach out directly.
Best regards,
Joyce
MSPbots Product Team
Ben Walter
The formula for Column C in that case was:
=AVERAGE(IF((C2:C6<>MAX(C2:C6))*(C2:C6<>MIN(C2:C6)), C2:C6))
Ben Walter
Yes I can. I specifically was asking in regards to my Performance Review Dashboard you helped create.
When taking in those numbers, sometimes the average is affected by a new employee who is obviously going to bring those numbers down. So I like to take into account that sometimes top/bottom performances skew the averages.
In my attached image I have shown my teams performance review based on that dashboard, showing the average of those employees and under the average I have removed the High/Low performances with the formula you can see in the screenshot.
J
Joyce
product review
J
Joyce
Dear Ben Walter，
Thank you for your patience.
Could you please provide a sample of your custom aggregates so that we may investigate the feasibility of achieving it?
Best regards,
Joyce
MSPbots Product Team