AppWithinMinutes Chart Macro
Zuletzt geändert von Steffen Rehfuß am 14.08.2026 18:21
This macro allows to show chart and data tables for AppWithinMinutes applications.
{{awmchart app="Help.Applications.Movies" category="databaseList1" type="pie" title="Chart" width="500" height="500" table="1" addParams="colors:C3E3F7,1D9FF5,015891,012A45" /}}
| Parameter | Description | Default Value |
|---|---|---|
| app | Application Name to get the data for the chart (corresponds to the space) | Empty |
| className | Class Name used alternatively to an Application name | Empty |
| category | Field on which the counting is made | status |
| type | Chart type (pie / bar / bar3D / line) | Empty |
| title | Title of the chart | Empty |
| width | Width of the chart | 500px |
| height | Height of the chart | 500px |
| table | Display of the data table (0/1) | 1 |
| chart | Display of the chart (0/1) | 1 |
| chartClasses | CSS Classes to add to the chart 'div' | col-md-6 col-sm-12 |
| tableClasses | CSS Classes to add to the table 'div' | col-md-6 col-sm-12 |
| useRow | Display of a bootstrap row (0/1) | 1 |
| colors | Colors to use for the chart (separated by commas) | backgroundColor:FFFFFF; legendBackgroundColor:FFFFFF; borderColor:FFFFFF; plotBackgroundColor:FFFFFF; plotBorderColor:FFFFFF; plotBorderVisible:false |
| addParams | Additional parameters for the chart in format key:value;key:value; (see the Chart macro documentation). | key:value;key:value |
| fromHQL | Additional HQL to add to the from part of the query (requires Programming Rights) | Empty |
| whereHQL | Additional HQL to add to the where part of the query (requires Programming Rights) | Empty |
| havingHQL | Additional HQL to add to the having part of the query (requires Programming Rights) | Empty |
| function | Function to apply to the category field. Non-date or multi-expression functions require Programming Rights. | Empty |
| aggregate | Aggregate field to use instead of count | Empty |
| aggregateFunction | Function to apply to the aggregate | sum |
| orderColumn | Column to sort the results on. The default is the first aggregated column | Empty |
| orderDirection | Direction to sort on (asc / desc) | desc |
| columnTitle | Title to use for the group column | Empty |
| aggregateTitle | Title to use for the aggregate column | Empty |
| nb | rendering.macro.awmchart.parameter.nb.description | 50 |
Example
Simple Chart
{{awmchart app="Help.Applications.Movies" category="databaseList1" type="pie" title="Chart" width="500" height="500" table="1" chartClasses="col-md-6 col-sm-12" addParams="colors:C3E3F7,1D9FF5,015891,012A45" /}}
| Director | Number |
|---|---|
| No value | 1 |
| Charlie Chaplin | 1 |
| Frank Capra | 1 |
Chart with function
{{awmchart app="Help.Applications.Movies" category="date1" type="line" title="Movies by year" width="500" height="500" table="1" chartClasses="col-md-6 col-sm-12" function="year" orderColumn="date1" orderDirection="asc" aggregateTitle="Movies by year" /}}
{{awmchart app="Help.Applications.Movies" category="date1" type="line" title="Movies by year" width="500" height="500" table="1" chartClasses="col-md-6 col-sm-12" function="year" orderColumn="date1" orderDirection="asc" aggregateTitle="Movies by year" nb="2" /}}
{{awmchart app="Help.Applications.Movies" category="date1" type="line" title="Movies by month" width="500" height="500" table="1" function="year(prop.value)*100+month(prop.value)" chartClasses="col-md-6 col-sm-12" orderColumn="date1" orderDirection="asc" aggregateTitle="Movies by month" columnTitle="Release Month" /}}
{{awmchart app="Help.Applications.Movies" category="doc.creationDate" type="Movies by creation month" title="Movies by creation month" width="500" height="500" table="1" function="year(doc.creationDate)*100+month(doc.creationDate)" chartClasses="col-md-6 col-sm-12" orderColumn="doc.creationDate" orderDirection="asc" aggregateTitle="Movies by creation month" columnTitle="Page creation month" /}}
| Release Date | Movies by year |
|---|---|
| 1936 | 1 |
| 1941 | 1 |
| No value | 1 |
| Release Date | Movies by year |
|---|---|
| 1936 | 1 |
| 1941 | 1 |
| Release Month | Movies by month |
|---|---|
| 193602 | 1 |
| 194105 | 1 |
| No value | 1 |
| Page creation month | Movies by creation month |
|---|---|
| 202608 | 3 |