Are you interested in taking a closer look at the data behind the monthly bars in the Usage Report? And maybe even explore Mestro’s tool for automatic gap filling? Then you should use the Data feature!
In the Usage Report, there is a button called called Data Source. See the image below.
Through this tool, you get more detailed information about the data included in the report. For example, you can see what percentage of the measurements were collected automatically versus manually.
This Data Source modal contains two tabs:
Data
Gap Filling
Data tab – full transparency on data coverage
Provides This tab provides a clear overview of monthly data coverage for the selected year in a simple bar chart. The modal shows all the data that the report is based on, including all settings and filters.
By hovering over a month, you get detailed information about shares of:
- Incoming data type
- Manually entered data
- Automatically collected data
- Missing data
- Top cutting
- Any data gaps
This gives you a quick understanding of how complete the underlying data is for each month in the reporting period.
Gap Filling
...
tab – Introduction to the Imputation Tool
This tab introduces our imputation tool in a separate view, so you can explore how missing data is filled in—without affecting the main report.
The imputation tool fills in data gaps, i.e., missing measurements in the data series. Mestro continuously fills in missing values for heating, cooling, and electricity (apart from solar electricity) meters by combining meter history with external variables such as outdoor temperature, time of day, and season. We continuously update our calculation method so that the imputed values reflect actual usage as accurately as possible when data points are missing. If we cannot find a strong enough correlation between usage and external variables, we do not fill in the values because we are not confident in the accuracy of the estimates.
The chart in this tab mirrors the report’s graph but with imputed values highlighted in purple.
...
- Original value
- Amount filled in
- Total – per measurement type.
