This question has been flagged
2 Replies
4048 Views

How can I display the average of the speed field, instead of the sum?

XML TREE

        <field name="arch" type="xml">
            <tree string="Models">
                <field name="deviceid" />
                <field name="devicetime"/>
                <field name="speed"/>
                <field name="address" />
                <field name="event" />
                <field name="leido" />
            </tree>
        </field>


XML SEARCH

        <field name="arch" type="xml">
            <search string="Vehicles costs" >
                <group expand="1" string="Group By">
                    <filter name="groupby_devieid" separator="1" context="{'group_by' : 'deviceid'}" string="Vehicle"/>
                </group>
            </search>
        </field>

Avatar
Discard
Author Best Answer

All records

Car 1
50
Car 1
60
Car 2
65


Grouped records

Car 1
55 (avg 50,60)  I need
Car 2
65




Avatar
Discard
Best Answer

Hi,

Try like thi by giving avg=""

<field name="probability" avg="Avg. of Probability"/>

See:-  https://www.youtube.com/watch?v=hMQaPyzIP6E

Thanks

Avatar
Discard