Customizing Data Reports

The customize menu of the report tool allows for further refinement of a loaded report through features like data condensing, data filtering, and enabling the data range of saved reports to be updated based on when it is loaded (instead of a fixed time interval).

If a report has not been created yet, reference the information in the article below to first generate a data report.

 

Select the Customize option.

Customize Option

 

The following features are available under the Customize menu:

Note: Click Apply once the changes are completed for each feature.

  • Data: This feature allows the user to change the timeline in which the data is displayed, and provides the option to condense the data.
    • The Condense option combines data points by taking the sum, average, minimum or maximum over a specified time interval.

Data Range option

 

  • A Custom range can be set for the data report.
    • The Fixed option provides a specified time and date for the report.
      • Data will always be loaded from the specified interval regardless of when the report is generated.

        Fixed custom interval. The Report will always contain data from 8/17/2018 to 8/19/2018.

    • The Last option provides a variable time period that can include data from the last minute, hour, day, week, or month.
      • This option is most commonly used for saved reports that are configured to send automatically via Email or FTP.
      • The current local time when the report is generated serves as the end point of the report .
      • The starting time of the data record is determined by the selected date range.

        Last interval option. In this example a report generated or loaded on 5-25-2019 at 3:45pm local time would contain data from 5-23-2019 at 3:45pm through 5-25-2019 at 3:45pm, a span of 2 days.

 

  • Filter: This feature allows the user to select a parameter in the report and set a minimum and maximum value for that parameter.
    • Choose a filter on the left, input a minimum and a maximum value, and then click add filter. The selected filters will be added on the right.
    • All available data for a given parameter that fall outside the designated Min and Max thresholds will be excluded from the report.

 

Filter Option

 

  • Header/Footer: This feature allows the user to change the header and footer displays on downloaded or exported reports.
    • Changes can be made to the header such as the title(s), date prepared, and time system used (12-hour or 24-hour).
      • These changes will be shown immediately at the top of the page.
    • Changes to the footer such as the page number display and any extra footer will be shown on the downloadable PDF format of the report.

Header/Footer Option

 

Bottom of the downloadable PDF page that contains the “Extra Footer” and the page number display

 

  • PDF Format: This feature allows the user to customize the downloadable PDF format of the data report.
    • Included in the PDF Format options are the paper size and orientation, along with the same section options available during the generation of the report on the WQData Live interface.

PDF Format Option

 

  • Settings: This feature allows the user to add a description of the site for future reference, and to change the time zone of the report to match the local time.
    • For a Memorized report, there is an additional Delete Report option.

Settings for a non-memorized report

 

 

Settings for memorized report