Show Posts
1
ParamQuery Pro Evaluation Support / Creating a custom average aggregate for grouped column summary
« on: June 14, 2018, 12:08:45 am »
We have a grid that is grouped on multiple columns.
One of the columns in the total number of calls made. Another column is the average call length of of all those calls.
We want the summary to show the total minutes / the total number of calls by grouped column. For example, if grouped by day then the summary needs to show all minutes for the day divided by all the calls for that day.
The default average would show an average of averages.
Is there a way to achieve this?
One of the columns in the total number of calls made. Another column is the average call length of of all those calls.
We want the summary to show the total minutes / the total number of calls by grouped column. For example, if grouped by day then the summary needs to show all minutes for the day divided by all the calls for that day.
The default average would show an average of averages.
Is there a way to achieve this?