This section helps you in creating report in Dashboards and Reports tool.

You may create a new report either:
  • In one of the standard dashboards available.
  • In a new dashboard (It requires a new dashboard to be created first).

In order to create a new report in one of the available standard dashboards, follow the procedure:

Procedure

  1. Navigate to the standard dashboard.
    For example: Main / Home > NCM dashboard.
  2. Click Add panel.
    New Panel window appears.
  3. Click Add new panel.
    A new page with wizards such as Queries, Visualization, General, etc, appears.

    In Query wizard, select Query data source as NCM-PostgreSQL (from drop-down), for the new report.

  4. Click Visualization on right hand pane and select Table.
  5. Select FROM table, SELECT Column, Time Column and WHERE fields as per the requirement. Click + to add more columns.
  6. Select Group by field as per the requirement.
  7. Select Format as Table.
    Note: In the above example, report for job status is being created.
  8. If you have the SQL query ready then instead of adding table and columns separately, you can add the whole query by clicking on the “pencil icon” below Query Inspector.
  9. In Settings in the right pane, enter appropriate panel title and description for the report panel.
  10. To put the report in the dashboard, click Apply > Save Dashboard > Save.
    Once the dashboard is saved, to view the report, launch the dashboard where the new report is created.