Report pivot

CLEM.Reporting.ReportPivot

This will perform a pivot style summary on the results of its parent report, saving the results to the database as a view that can be graphed or displayed.

While the standard reports (e.g. Resource ledger report) provide all the information needed to summarise your model result, they are often not the best format to quickly summarise the model runs. This report component allows you to perform a pivot style summary (akin to Microsoft Excel pivot table) on any APSIM report (parent component in tree) with the results saved to the database for further analysis or graphing.

The following parameters are used to define this activity and entered under the Properties tab in the user interface

This value represents the name of the column from the parent report database table which will be summarised and provided in each cell of the pivot table.

This value represents the name of the column from the parent report database table from where the values defining the rows of the pivot table will be provided.

This value represents the name of the column from the parent report database table from where the values defining the columns of the pivot table will be provided.

The filter applied to the time (date) for which to summarise values.

This represents the style of aggregating values and can be:

  • Sum: sum all values
  • Average: The average value
  • Min: the minimum value
  • Max: the maximum value
  • Count: the number of entries

This ReportPivot will generate a table with rows and columns representing the values provided from the column names specified. The cells will be filled with the aggregated values of the value column using the method specified. This table will be saved to the simulation database using the name provided for the component.

See also