What is Statistics?
The Statistics panel in the Data Explorer lets you quickly calculate relevant summary metrics for different attributes in a dataset you have downloaded to the map. It allows you to get these summary metrics without the need to export the dataset to process.
Using the Statistics panel
Navigate to the Data Explorer
Download the relevant datasets you want to query
In the top right corner of the screen click the "Statistics" button
The Statistics panel will then open on the right hand side of the screen
In the Select a Dataset dropdown, choose the dataset you want to analyse
If no dataset is currently downloaded, the panel will prompt you to do so
In the Select a Column dropdown, choose the attribute you want to query
Numeric columns are best suited to statistics such as min, max, sum, average and standard deviation.
Categorical or text columns will return counts for each unique value.
Running the query
After choosing your dataset, column and options, click Run Query at the bottom of the Statistics panel. The Results section will then populate with a table for each dataset you queried, each result is defined below:
Statistics - the dataset and column used
MIN - the smallest value in your dataset
MAX - the largest value in your dataset
SUM - the total of all values in your dataset
AVG - the average value (mean)
STD DEV - the standard deviation, indicating how spread out the values are
COUNT - the number of records included in the query
Example Use Case
The Registered Installations (MCS) dataset provides information on all MCS certified small scale renewable installations at LSOA level within your Local Authority boundary. Using this dataset with the Statistics panel lets you understand existing installations across the LA.
To quantify existing installations using this dataset and the Statistics panel:
In the Data Explorer, download the Registered Installations (MCS) from the Energy Assets folder
Open Statistics in the top right of the map and select the MCS dataset in the Select a Dataset dropdown
Choose columns such as ASHP Installations and ASHP Capacity
Add the metrics to calculate - MIN, MAX, SUM, AVG, STD DEV and or COUNT
MIN, MAX - Number of installations/ capacity in the least and most populated LSOAs
AVG, STD DEV - Typical uptake and systems and systems sizes at LSOA level
SUM - Total installations/ capacity across the whole local authority
COUNT - The number of LSOAs within the LA
Because the MCS Installations Database is the national record of certified small‑scale renewables, using it alongside the Statistics panel provides a baseline of existing technologies across your local authority.
Using Filtered Datasets
Filtered Datasets lists any datasets you have downloaded to the map and then filtered using the Filters tab in the Data Explorer. When you select a filtered dataset in the Statistics panel, all metrics are calculated only for records that match the applied filters. For example, you can filter a rooftop PV suitability dataset for Overall suitability = True - querying this allows you to understand the statistics behind strictly PV suitable homes in your local authority.
Exporting results
To download your results for external use click "Download as CSV" in the top right corner of the Results section. The CSV file will download to your device and include the statistics currently displayed in the table for each query you have run.
Resetting the panel
Click "Reset" at the bottom of the Statistics panel to clear the current query and results. You can then select a new dataset and column and create a fresh query.