Use this Knowledge Script to generate a report containing a chart and table showing the average, maximum or minimum value of each selected datastream.
This report allows you to set the maximum number of data points illustrated in the chart, regardless of the number of data points that have been collected. For example, you may be collecting data every five minutes, but you want to report on the daily maximum value for the last week. Set the time range to 7 days, and set the maximum number of points per chart to 7. The report aggregates the data in increments of one day, and the chart illustrates seven maximum values for each selected datastream. The table in the report mirrors the chart settings: in this case, the table has seven rows of data.
The number of points in the chart do not have to correspond exactly to the time period on which you are reporting. You can illustrate a year’s worth of data using 50 or 100 points, and you can illustrate a day’s worth of data using 50 or 100 points. This script aggregates the data in the report according to the time range and points per chart settings.
This feature is useful for illustrating any time period in a single chart.
Report agent
The default schedule is Run once.
Set the following parameters as needed:
Parameter |
How To Set It |
---|---|
Data source |
|
Select data wizard |
Select the data for your report by Knowledge Script or by datastream. |
Select the style |
Select the style for the first page of the report:
|
Select time range |
Filter the data for your report by a specific or sliding time range. |
Select peak weekday(s) |
Filter the data for your report by days of the week. |
Maximum number of points per chart |
Specify the maximum number of data points illustrated in the chart. The default is 200. Possible values range from 5 to 1000. |
Select average, minimum or maximum |
Select the type of value you want in the report. |
Report settings |
|
Include parameter help card? |
Set to y to include a table in the report that lists parameter settings for the report script. The default is y. |
Include table/chart/both? |
Select the type of datastream values you want to include in the report:
|
Select chart style |
Define the graphic properties of the charts in your report. |
Select output folder |
Set parameters for the output folder. |
Add job ID to output folder name? |
Set to y to append the job ID to the name of the output folder. A job ID helps you correlate a specific instance of a Report Script with the corresponding report. The default is n. |
Select properties |
Set miscellaneous report properties as desired. |
Add time stamp to title? |
Set to y to append a time stamp to the title of the report, making each title unique. The time stamp contains the date and time the report was generated. A time stamp allows you to run consecutive iterations of the same report without overwriting previous output. The default is n. |
Event notification |
|
Event for report success? |
Set to y to raise an event when the report is successfully generated. The default is y. |
Severity level for report success |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 35 (magenta level indicator). |
Severity level for report with no data |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 25 (blue level indicator). |
Severity level for report failure. |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red level indicator). |