Configure average reports

To update, open your configuration file and set the following parameters for all report objects with "Type": "AVERAGE".

Parameter Description
Description Parameter that defines the report, this parameter is not used in any process and is only provide to assist configuration
Type The type of report configuration.
RunReport True or False parameter to determine if the report section should be bypassed.
Data The data layer being summarized and used to calculate the average reports.
FilterSQL The SQL statement used to filter the "Data" layer. To evaluate all features within the data layer, use the statement "1=1".
UseArcMapExpression True or False parameter to determine if the PreCalcExpression should use the field calculator or python to process each row. If False, you need to define the fields in the field map.
FieldMap (Only required when UseArcMapExpression is False) Array of fields within the data layer used to calculate the average report. For each object in the array the, the following must be defined:
  • FieldName: data layer's field
  • ReplaceValue: value used in the average report expressions
PreCalcExpression Expression to pre-process the data using python syntax. For example, if evaluating performing calculations based on the age of an asset, this field calculate the age from the date field.
ReportResultSchema Feature class schema of the resulting average calculation.
ReportResult Resulting average report feature class.
ReportDateField Date field in the report result layer. This field is calculated with the date and time the report is run.
ReportIDField Unique ID field in the report result layer. This field is calculated using the unique ids of the reporting areas layer features.
ReportOutputType Parameter to determine if the output should be appended to existing data, overwrite the layer or update the reporting data. Values: Overwrite, Append, Update
ReportMerge True or False parameter to determine if the report results should be merged into the CSV output if a path is specified, in the CSVOutputLocation parameter.
AverageToResultFieldMap Array of fields in the average report layer. For each object in the array, the following must be defined:
  • FieldName: Field that will be calculated
  • Expression: Python expression used to calculate the field
Top