I can't say I really understand, but do agree that you can't have two different aggregations on the same column. We usually set up two columns, for example, one with a SUM aggregation and the other with an AVG aggregation and coach the users on which number to focus on. Not sure if that solves your ...