Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

Odoo 8 Reporting : Get data average instead of data sum

system override odooV8 Reporting

1 Vastaa

12401 Näkymät

TEIMI Yassine

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.

Axel Mendoza

Paras vastaus

@Yassine TEIMI

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

TEIMI Yassine

Tekijä

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.

Axel Mendoza

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'

Axel Mendoza

did you test it?

TEIMI Yassine

Tekijä

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

TEIMI Yassine

Tekijä

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

Axel Mendoza

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

TEIMI Yassine

Tekijä

How is it possible to do it with an extension ?

Axel Mendoza

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

TEIMI Yassine

Tekijä

Done : https://www.odoo.com/fr_FR/forum/help-1/question/odoo-8-reporting-change-default-total-label-94772 Thanks a lot Axel.

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
[Odoo 8] override function override odooV8	1 heinäk. 15	4108
How to create/insert multiple row in single action? Ratkaistu create override odooV8	2 helmik. 22	18199
How to override a default module using a custom module (e.g. override the 'web' module in order to modify the login screen & rem Ratkaistu templates override odooV8	2 jouluk. 23	24633
Add sanitize = False attribute to field. fields override clean odooV8	0 toukok. 24	10435
How to find the id of a menuitem? Ratkaistu menuitem id odooV8 Reporting	3 tammik. 19	30233

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!