Menu

Add a new report

Add a new report using report queries. Report queries are for filtering data or viewing statistics from the aggregate table in the Knox Manage database.

To add a new report using report queries, complete the following steps:

1. Navigate to Advanced>Report.

2. On the “Report” page, click Add.

3. In the “Add Report” window, enter the report information:

  • Report ID: Enter the ID for the new report.
  • Report Name: Enter the report name.
  • Description: Enter a description for the report.
  • Report Queries: Select the report query for the report. For more information, see Report queries list.
  • Chart: Select the chart type of the report.
  • Legend: Select the location of the chart legend.

4. Click Add next to Output Fields.

5. In the “Add Output Field” window, click the checkboxes for the report fields you want to add and click OK.

6. Configure the detailed settings of the selected fields depending on their data types.

  • To delete selected fields, click the checkbox for the fields you want to delete and then click Delete.
  • To rearrange the selected report fields, click the checkbox for a field and click or .

Data type

Setting

String

  • Output Name: Change the field name if necessary.
  • Chart Setting: Select the field as the chart category if you want to display the chart.

Number

  • Output Name: Change the field name if necessary.
  • Output Format: Select the number display format.
  • Summary Type: Select the numeric value to display on the chart from among sum, average, maximum, and minimum.
  • Chart Setting: Select the field as the chart series or category if you want to display the chart.

Date

  • Output Name: Change the field name if necessary.
  • Output Format: Select the date display format.
  • Chart Setting: Select the field as the chart category if you want to display the chart.

7. Click Save.

8. In the “Save Report” window, click b.

Adding a report based on an existing report

To copy an existing report to create a new report, complete the following steps:

1. Navigate to Advanced > Report.

2. On the “Report” page, select the report you want to copy and click Copy.

3. On the “Copy Report” page, enter the report name and ID.

4. Modify the existing information if necessary.

5. Click Save.

6. In the “Save Report” window, click OK.