Skip to content
English
Contact us
Contact Us
  • There are no suggestions because the search field is empty.

Create a Summary Statistics Report

Learn how to generate a CSV of descriptive statistics for up to 50 sensors over a date range you choose.

Table of Contents

About the Summary Statistics Report

Summary Statistics is a standard report type in Conserv Cloud. It produces a CSV file containing descriptive statistics for each sensor you select (up to a maximum of 50), calculated over the date range you choose.

Use this report when you want to compare a large number of sensors at once, for example:

  • Reviewing conditions across every space in a building before an annual report
  • Comparing cases or storage areas to find the most and least stable locations
  • Pulling minimum, maximum, and mean values for a loan or exhibition period
  • Summarizing a season or quarter without exporting every individual reading

Note

Summary Statistics returns one summary row per sensor and reading type. To work with individual readings, use the CSV environmental data export instead.

Before You Begin

Ensure you have:

  • A Conserv Cloud account with access to the Reports page
  • Sensors that reported data during the date range you plan to use
  • Filled any gaps in Conserv SCS devices if needed (See Infill Missing Data)

Generate a Summary Statistics Report

  1. Sign in to Conserv Cloud.
  2. Select Reports in the left navigation.
  3. Select the CREATE REPORTS tab.
  4. Locate the Summary Statistics card and click create report.
    The Summary Statistics dialog opens.
  5. In the Sensors field, search for and select the sensors or spaces you want to include.
    Each selection appears as a chip above the search field. Click the X on a chip to remove one selection, or click Clear to remove all selections.
  6. Under Date range, enter a Start Date and an End Date.
  7. Under Reading types, select the checkbox for each reading type you want in the report.
  8. Click GENERATE CSV.
    The CSV downloads to your computer with a file name in the format summary-statistics_YYYYMMDD-YYYYMMDD.csv.

Tip

Selecting a space includes all the sensors in that space, which is faster than selecting each sensor individually.

Reading Types

Select any combination of the following reading types:

  • Temperature
  • Relative Humidity
  • Dewpoint
  • Illuminance
  • UV

Note

A sensor only produces rows for the reading types it measures. If you select a reading type that a sensor does not measure, no row appears for that combination.

Conserv SCS devices only have illuminance over serial c006000 and UV over c008500.
Freezer sensors and Outdoor sensors only have Temperature and Relative Humidity.
Cryo sensors only have Temperature.

Understand the CSV

The file opens in any spreadsheet application. It contains a short header block followed by one row per sensor and reading type.

Report Header

  • Date range: The start and end dates used for the calculations

  • Timezone: The time zone the date range was applied in

  • Generated: The date and time the report was created

Statistics Columns

  • Sensor: The name of the sensor
  • Space: The space the sensor is assigned to
  • Reading Type: The reading type the row summarizes, for example Temperature
  • Min: The lowest reading recorded during the date range
  • Max: The highest reading recorded during the date range
  • Mean: The average of all readings during the date range
  • Range: The difference between Max and Min
  • Std Dev: The standard deviation of the readings, which indicates how much conditions varied
  • Unit: The unit of measure for the row, for example °F or %

Note

A sensor that reports more than one reading type appears on more than one row, with one row for each reading type you selected.

Limits and Considerations

  • You can include up to 50 sensors in a single report.
  • Statistics are calculated only from readings that exist in the selected date range. Gaps in data, for example from a sensor that was offline, reduce the number of readings included in the calculation.
  • Statistics are calculated in the time zone shown in the report header.
  • The report is delivered as a CSV file. It is not saved in Conserv Cloud, so generate a new report whenever you need updated numbers.

Caution

Compare Std Dev values with the number of readings in mind. A sensor with a large data gap can appear more stable than it was, because fewer readings contributed to the calculation.