Group by two values

Technologies > User Interface Add-Ins > Grouping Views > Grouping DataSource

The first example groups rooms by room standard and department, and return total room area for each room standard-department grouping:

<dataSource type="grouping">
<table name="rm"/>
<field name="rm_std" groupBy="true"/>
<field name="dp_id" groupBy="true"/>
<field name="total_area" formula="sum" baseField="rm.area"
dataType="number" size="6" decimals="0">
<title>Total Area</title>
</field>
...
</dataSource>

View: http://localhost:8080/archibus/schema/ab-products/solutions/parts/chart/ab-ex-grouping-ds.axvw