...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<!-- Create a new data definition that groups the values based on their 'group' value -->
<data:datadefinition id="test.group">
<groupdataconnection datadefinition="test.source">
<parameter name="group" label="Group" column="group"/>
<parameter name="sum" label="Sum" column="sum(value)"/>
<parameter name="avg" label="Average" column="avg(value)"/>
<parameter name="min" label="Minimum" column="min(value)"/>
<parameter name="max" label="Maximum" column="max(value)"/>
<parameter name="count" label="Count" column="count(1)"/>
<group column="group"/>
</groupdataconnection>
</data:datadefinition>
|
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<!-- Create a new data definition that groups the values based on their 'date' value -->
<data:datadefinition id="test.group">
<groupdataconnection datadefinition="test.source">
<parameter name="group" label="Group" column="date"/>
<parameter name="sum" label="Sum" column="sum(value)"/>
<parameter name="avg" label="Average" column="avg(value)"/>
<parameter name="min" label="Minimum" column="min(value)"/>
<parameter name="max" label="Maximum" column="max(value)"/>
<parameter name="count" label="Count" column="count(1)"/>
<group column="date"/>
</groupdataconnection>
</data:datadefinition>
|
...
group | sum | avg | min | max | count |
|---|---|---|---|---|---|
1-jan-2000 | 7 | 2.33 | 1 | 4 | 3 |
2-jan-2000 | 10 | 3.33 | 2 | 5 | 3 |
3-jan-2000 | 6 | 2 | 1 | 3 | 3 |
4-jan-2000 | 1 | 1 | 1 | 1 | 1 |
...
...
1 |
...