This is the documentation for older versions of Odoo (formerly OpenERP).

See the new Odoo user documentation.

See the new Odoo technical documentation.

Graph views

A graph is a new mode of view for all views of type form. If, for example, a sale order line must be visible as list or as graph, define it like this in the action that open this sale order line. Do not set the view mode as "tree,form,graph" or "form,graph" - it must be "graph,tree" to show the graph first or "tree,graph" to show the list first. (This view mode is extra to your "form,tree" view and should have a separate menu item):

<field name="view_type">form</field>
<field name="view_mode">tree,graph</field>


tree = (tree with shortcuts at the left), form = (switchable view form/list)


tree,graph : sequences of the views when switching

Then, the user will be able to switch from one view to the other. Unlike forms and trees, OpenERP is not able to automatically create a view on demand for the graph type. So, you must define a view for this graph:

<record model="ir.ui.view" id="view_order_line_graph">
   <field name="name">sale.order.line.graph</field>
   <field name="model">sale.order.line</field>
   <field name="type">graph</field>
   <field name="arch" type="xml">
         <graph string="Sales Order Lines">
              <field name="product_id" group="True"/>
              <field name="price_unit" operator="*"/>

The graph view

A view of type graph is just a list of fields for the graph.

Graph tag

The default type of the graph is a pie chart - to change it to a barchart change <graph string="Sales Order Lines"> to <graph string="Sales Order Lines" type="bar"> You also may change the orientation.

:Example :

<graph string="Sales Order Lines" orientation="horizontal" type="bar">

Field tag

The first field is the X axis. The second one is the Y axis and the optional third one is the Z axis for 3 dimensional graphs. You can apply a few attributes to each field/axis:

  • group: if set to true, the client will group all item of the same value for this field. For each other field, it will apply an operator

  • operator: the operator to apply is another field is grouped. By default it's '+'. Allowed values are:

    • +: addition

    • *: multiply

    • **: exponent

    • min: minimum of the list

    • max: maximum of the list

Defining real statistics on objects:

The easiest method to compute real statistics on objects is:

  1. Define a statistic object which is a postgresql view

  2. Create a tree view and a graph view on this object

You can get en example in all modules of the form: report_.... Example: report_crm.