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 the enabling of variable upload intervals (instead of a fixed time interval).

If a report has not been created yet, reference Generating Data Reports to first create a data report.

Once a report has been generated, select Customize at the top of the page.

Customize menu.

 

The following features are available:

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

  1. Data: This feature allows for changes to the time range for which data is displayed and provides the option to condense the data.

Date Range and Condense fields.

 

    1. For the Date Range, a set interval may be chosen, or select Custom to manually set the data report time constraints.
    2. Select Fixed to set a specified time and date for the report. Note that data will always be loaded from the specified interval regardless of when the report is generated if this option is selected.

Fixed custom interval example where report will always contain data from 8/17/2018 to 8/19/2018.

 

    1. Select Last to have the report always include the most recent data for the time period specified in the Range field.
      • 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 example where report would always contain the most recent 2 days of data when loaded or automatically sent.

 

    1. The Condense option combines data points by taking the sum, average, minimum or maximum over a specified time interval.

 

  1. Filter: This feature allows selection of minimum and maximum values for a parameter shown in the report.
    1. Choose a parameter from the Filter Parameters list on the left, input a minimum and a maximum value in the Min and Max fields, respectively, and then click Add Filter. The selected filters will appear in the list on the right.
    2. All data points for a given parameter that fall outside the designated Min and Max thresholds will be excluded from the report.

Filter Parameters configuration menu.

 

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

Header/Footer configuration menu.

 

Example footer on the downloadable PDF report that contains the Page Number display and Extra Footer content.

 

  1. PDF Format: This feature customizes the downloadable PDF format of the data report.
    1. Included in the PDF Format options are the paper size and orientation and the ability to toggle various report sections on and off (the same options available during the generation of the report on the WQData LIVE interface).

PDF Format configuration menu.

 

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

Settings for a non-memorized report.

Settings for a memorized report.