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

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.

The output fields must include at least one Category field and one Series field. There must be two or more fields.

  • The Category field shows the chart label, and you can use all data types to represent a chart label.
  • The Series field contains the data to be displayed on the chart, and you can only use the number data type to represent chart data.
  • If the chart type is Pie or Donut, the chart can only contain one Series field. For other chart types, the chart can contain multiple Series fields.

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.