Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
1 Trả lời
11723 Lượt xem

On odoo reporting, there is by default a total row giving the float or integer field sum, this field is on the measure selection box
There is necessarily a method allowing to do a sum operation (maybe using sum sql aggregate function), I want to override this method to allow me do a data average (maybe a svg sql aggeregate function) instead of sum, and just for one specified reporting (the one I'm developping), and not for all Odoo reportings.

Here is a picture that summarizes what I want to do.

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

@Yassine TEIMI

To change that you just need to define group_operator = 'avg' in the measure field definition of the model class

Ảnh đại diện
Huỷ bỏ
Tác giả

So I should overwrite the measure field definition on the report model I'm using, then I can get the avg as a operator only for desired report ? on the other hand, I'm looking for the original measure field definition, on the models.py (ORM) but can't find it.

when I said measure field definition I really mean to say the definition of the field used as measure of the pivot table graph view that you need to group using avg, that field in your report model need to have the group_operator = 'avg'

did you test it?

Tác giả

Great ! It works fine, thanks a lot Axel :)

Tác giả

@Axel, How can I change the 'total' string (see http://prntscr.com/9eexf9) in to 'average' ?

I don't know how to do it without an extension

Tác giả

How is it possible to do it with an extension ?

Please create another question for that, to explain all the steps of how to do it in an answer without mix things

Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 7 15
3481
2
thg 2 22
17150
2
thg 12 23
23473
0
thg 5 24
9483
3
thg 1 19
28562