Skip to Content
Menu
This question has been flagged
1 Reply
12515 Views

Hi,

by clicking on a group in a search view, the records in the list view get grouped. The records representing a group automatically sums integer or float fields. But is there a way to change this aggregation behavior? For certain fields, I would like to see the average instead of the sum. 
Is there a way?

 

Avatar
Discard
Best Answer


Hi Gregor Heger

You need to define the field group_operator that by default is sum even if you don't specify it. That it's defined directly in the field, like:

count = fields.Integer('Count', group_operator='avg')
Avatar
Discard
Author

It works! Thank you very much!

Happy to help

How can add some other calculation in group_by. For an example if we need division on two grouped value, how we can do that?

Related Posts Replies Views Activity
2
Nov 24
44100
1
Apr 21
11571
1
May 25
772
4
Jan 24
22953
2
Jan 24
2312