...
In the dashboard view, users can easily filter a metric with the set parameters. This real-time adjustment of parameters allows the metric to be recalculated on the fly, which enhances the analysis process.
...
Create Parameters
Before using parameters with a custom metric on a dashboard it is necessary to add Parameters and configure them via PerfQL.
...
| Warning |
|---|
Parameter name must be unique within one metric. |
Select a Type
| Info |
|---|
There are three types of parameters are possible to use:
|
Set Default value
| Tipinfo |
|---|
For the Date field type set a date you would like to use as a default one. Based on this date a metric will be calculated for default view. There is one date is possible to set within one field. After setting value(s) for the Dropdown list type click on the default field and select the value(s) you would like to set as a default. Based on selected values a metric will be calculated for default view. It is possible to select several values. For the Input field type specify a custom value based on which you would like the default metric view to be calculated on. It is possible to use text, numeric, order formats. |
Click ‘Add’ button
The added parameters become visible at the Data Selection step of the ‘Create New Metric’ or ‘Edit Metric’ custom metric stepper.
| Tip |
|---|
The system automatically applies the '$' symbol to a name to make parameters distinctive. |
Step 2: Configure Parameter
At this step it is necessary to configure added parameters as variables with set values using PerfQL.
Example:
A metric shows top-N tickets creators with a specific ticket type, created after a certain date and set limit of output data.
For the metric we have to create 3 types of parameters:
for the ticket type (Dropdown list type) - $type$
for created after (Date field type) - $created_after$
for limit (Input field type) - $n$
PerfQL:
select reported_by, count(*)
from Ticket
where type in $type$
and created > $created_after$
group by reported_by
order by count desc
limit $n$
...
Edit Parameters
The added/configured parameters are possible to Edit on the ‘Create New Metric’ or ‘Edit Metric’ custom metric stepper.
Hover on a Parameter and click Edit button
...
On the ‘Edit Parameters’ form make changes and click Save for updating the Parameter.
...
| Note |
|---|
Please do not forget to update the changed parameter in PerfQL if necessary. |