If you customer complaints and water service connection schema differs from the sample data provided, the Join, Calculate, Load report in the Customer Complaints configuration filed need to be update to match your schemas.
To update the configuration file, browse to your download and open the Customer Complaints JSON file. Then, update the report with "Type": "JoinCalcAndLoad" to match the following parameters with your utility's data.
To update, open your configuration file and set the following parameters for all report objects with "Type": "JOINCALC".
Parameter | Description |
Data | The data that will be joined to an existing feature class based on unique id and remapped to the report schema feature class. Valid types of data include feature classes or CSVs. |
DataIDField | Unique ID field in your data parameter. |
JoinInfo |
Section defining the joining feature class properties.
|
FilterSQL | The SQL statement used to filter the data parameter. To evaluate all features within the data CSV or layer, use the statement "1=1". |
FieldMap | The mapping of fields from the data layer to the resulting report schema feature class. For each object in the array the, the following must be defined:
|
ReportDateField | Date field in the resulting report feature class. This field is calculated with the date and time the report is run. |
ReportResultSchema | Feature class schema of the resulting from the join, calculate, load report. |
ReportResult | Resulting feature class. |