Inspection Reading Spread
Summarizes instrument readings by site with count, minimum, and maximum values, and can add the arithmetic mean without changing the grouping or source data.
About this Model
Inspection Reading Spread is an operations analysis model that imports eight instrument-reading records from a flat JSON source and summarizes them by site. It creates a Site Spread group with row count, minimum reading, and maximum reading, then saves the grouped output as a Reading Spread view. A Change action adds the arithmetic mean for each site while preserving the existing grouping and spread columns. Reset removes generated groups, views, datasets, and settings while retaining the original source, schema, model structure, and agents. A subsequent Run restores the default count, minimum, and maximum output without the mean. Repeated runs and identical changes retain the current configuration without duplicate results.
- Groups all eight source readings by site, including zero and negative values.
- Calculates reading count, minimum, and maximum in a flat grouped result.
- Adds mean reading through Change while preserving the group and spread columns.
- Maintains lineage from readings.json to Site Spread to Reading Spread.
- Reset removes generated outputs while preserving the imported source and agent hierarchy.
- Repeatable Run and Change actions avoid duplicate groups and views.