Overview

The parameters provides a user an opportunity during a custom metric creating to have the flexibility to add values that allow for more tailored analysis. There are three types of parameters that can be added: Drop-down list, Date, and Input. With these parameters, users can configure specific values for the custom metric to better fit their needs.

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 Parameter

Before using parameters with a custom metric on a dashboard it is necessary to add Parameters and configure them via PerfQL.

Step 1: Add Parameter

At the Data Selection step of the ‘Create New Metric’ or ‘Edit Metric’ custom metric stepper click on the plus button at the Parameters option.

On the Add Parameters form fill in the required fields:

Specify a Parameter Name

Parameter name must be unique within one metric.
Please avoid using spaces in a parameter name.
The ‘clicked_x_value’ name is not allowed to use.

Select a Type

There are three types of parameters are possible to use:

Date field - contains a Calendar. Using this option you are able to configure a specific date.
Dropdown list - allows to create a set of values which will be possible to apply to the metric and select on a dashboard.
Input field - allows to specify your own custom value(s).

Set Default value

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 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.

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 Parameter

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 the Save button for updating the Parameter.

Please do not forget to update PerfQL for the changed parameter if necessary.

Delete Parameter

The added/configured parameters are possible to Delete on the ‘Create New Metric’ or ‘Edit Metric’ custom metric stepper.

Hover on a Parameter and click the Bin button

Please do not forget to update PerfQL for the deleted parameter if necessary.

Filter a metric via Parameters

After Parameter(s) was added and configured successfully it becomes possible to filter a metric on a dashboard. By default the metric is calculated based on default values that were entered during parameters creation.

On a metric click three dots menu > Configure Parameters or the special button on a metric.
On the Configured Parameters form make necessary changes and click ‘Update’ button.

The system recalculates the metric based on the updated Parameters.

You can see the configured parameters at a metric via the hovering on the parameters button.

All Rights Reserved. All information contained herein is, and remains the property of EPAM Systems, Inc. and/or its suppliers and is protected by international intellectual property law. Dissemination of this information or reproduction of this material is strictly forbidden, unless prior written permission is obtained from EPAM Systems, Inc.

Metric Parameters