Summary Reports

Summary Reports

Several annual, monthly, daily and special summary reports come standard with DataSight and are a fixed type reporting solution. You can simply select the date ranges, levels and variables from your database and the type of summary (total, average etc) that you wish to view in a report. You cannot change the report layouts but you can determine the output file type and save them to Saved Views.

For the most part, the reports are tabular summary statistic reports (such as average, maxima, minima and totals) for a designated time period as indicated in the table below and are therefore sometimes referred to as Tabular Reports. More specialised report templates have been built for Meteorological and Hydrological Data, such as Rainfall Intensity, Wind Roses, IDF Curves and Pentads.

 

Display the Summary Reports List

  1. Click Summary Reports in the Output Group of the DataSight Ribbon. The Summary Reports List will appear.
  2. Select the Summary Report you wish to run.

 

Types of Summary Reports

Summary Reports are available for the following purposes and reporting periods.  Please also note the period definitions.

Report Type

Purpose

Reporting Period

Basic Statistics

Average, standard deviation, maximum, minimum and median data over a given time period

Enter a Date Range or a Period

Annual

Average or cumulative reports over 12 months

Enter Year

Monthly - Daily Basis

Daily averages or totals for multiple variables

Enter Year and Month

Monthly - Hourly Basis

Monthly tabular report for individual variables in hours

Enter Year and Month

Daily

Average and total figures hourly over the day

Enter the Date

Standards - Exceeding Data

Identifies all occurrences of exceeding data for selected variable(s) against a chosen Standard

Enter a Date Range or a Period

Data Recovery

Identifies the operational days for selected variables within the specified date range, and calculates the percentage data recovery

Enter a Date Range or a Period

Operational Days

Identifies the number of operational days for selected variables only between the first and last days identified as operational

Enter a Date Range or a Period

Wind Direction

Displays a wind rose showing the frequency of winds blowing from particular directions

Enter a Date Range or a Period

Wind Rose

 

Displays a wind rose showing the percentage of counts of a Dependant Variable by Wind Direction.

Enter a Data Range or a Period.

Rainfall Intensity

Displays the amount of rainfall received per intervals of time

Enter a Date Range

IDF Rainfall

Displays an Intensity-Duration-Frequency curve (IDF Curve) for using instantaneous rainfall data.

Enter a Date Range

IDF Discharge

Displays an Intensity-Duration-Frequency curve (IDF Curve) for discharge data.

Enter a Date Range

Pentad Wet

Provides total precipitation estimates over 5-day pentads to define the start of the wet season

Enter a Date Range of at least four months and no greater than one year

Pentad Dry

Provides total precipitation estimates over 5-day pentads to define the start of the dry season

Enter a Date Range of at least four months and no greater than one year

Gage Height and Discharge

Provides tabular representation of the water level values adjusted according to discharge after carrying out a Shift Analysis.

Enter a Date Range

Expanded Conversion Table

Displays an expanded table of Conversions for interpolated variable values

Enter a Variable range and difference between rows

Moving Average

Displays the moving average over a specified number of points

Enter a Date Range

Reference Group

Displays data showing the Variable names specified in the selected Reference Group

Enter a Date Range or a Period.

 

Note

In preparing a Summary Report, DataSight operates only on numeric values, extracted from the value string. For example, <0.1 is treated as 0.1 for the purposes of generating the report.

Only records that are able to generate a numeric value are included in the record count.  Records whose data values are non-numeric will be ignored.

 

Period Definitions

Period

Definition

Is Last Hour

Last 60 Minutes, filtered immediately from the current date and time on your local PC.

Is Last Day

Last 24 Hours, filtered immediately from the current date and time on your local PC.

Is Last Week

Last 7 Days, filtered immediately from the current date and time on your local PC.

Is Last Month

Last Calender Month, filtered immediately from the current date and time on your local PC.

Is Last 3 Months

Last 3 Calender Months, filtered immediately from the current date and time on your local PC.

Is Last 6 Months

Last 6 Calender Months, filtered immediately from the current date and time on your local PC.

Is Last Year

Last Calendar Year, filtered immediately from the current date and time on your SQL local PC.

 

    • Related Articles

    • Reports in Saved Views

      Reports saved to the Saved Views may be opened and edited using different filter conditions than those originally saved with the report. This allows you to design a standard template for your reports that you can apply to different sets of data. ...
    • Gaugings Reports

      Two reports have been designed for stream gauging data. These are the Gauging List report showing a selection of stream flow measurements and the Gauging Details report for an individual gauging, which provides a graphical representation of both the ...
    • Summary Statistics

      Within a datasheet, you can easily calculate and display summary statistics for your data values using grouping. Data grouping sorts data into groups with the same value, whether this be a variable value, a date, time or any other column of data. By ...
    • Automatically Publish Reports

      Automated publication of reports in a chosen format can be scheduled using a Saved Datasheet. From within the Tasks grid view, either double-click on a selected task row, or click on the Edit The Edit Tasks dialogue window appears. Choose the Saved ...
    • Print Preview Reports

      Reports can be viewed in a Print Preview window prior to saving, printing or exporting. When you view a Preview window, you will see your report populated with data and broken down into pages, as specified. When in the Preview mode, you can print out ...