Metrics

From this section the Administrator can create Custom Metrics by clicking on the button “New Metric” and filling the following form, providing the Metric Name and Description:

From this section the Administrator can create Custom Metrics clicking on the button “New Metric” and filling the following form, providing the Metric Name and Description.

After the Metric creation, you have to specify the relative Query, by clicking on the Edit button.

Here you can find the Edit Metric Section that shows:

1. General Settings, where you can edit the following Metric parameters:

  • Name: The Metric Name, assigned in the creation form
  • Description: The Metric Description, assigned in the creation form
  • Tables for join: The tables of your database that you want to join for the query

2. Query, where you can define and type your SQL Query:

3. Help, where you can find a list of the Asterisk’s tables columns in the database, really useful to build your own Query

The created Metrics can be used in the Report section, also combined with other queries, to obtain interesting and complex reports.

Examples: