Metrics

Metrics are a result of calculations performed on a view by aggregating the data. They serve as a summary.

Creating Metrics

You can create Metrics in the following manner:

• Create from the Metric menu in the column header. Only one column is aggregated here.

• Create from Add metric dialog. This is opened from the metric panel. More than one column’s aggregation can be combined from here.

All metrics are displayed on the Metric panel available on the right hand side of the data grid. By default, the Metric panel is hidden. You can open the panel by clicking on the toggle button on the right hand side of the data grid. The panel automatically opens when a new metric is added.

The metrics react to the filters set by the Explore Cards.

Managing Metrics

Following options are displayed on a metric when you hover the pointer over it. They help you manage these metrics easily:

• Copy to Clipboard: This option lets you copy data from a Metric to your clipboard.

• Duplicate: This option lets you duplicate a metric if you want to create similar metric.

• Edit: Opens up the Metric Dialog.

• Delete: This option allows you to delete metrics.

• Lock: This option prevents a metric from reacting to explore cards.

Fig. 142 Metric Options

Metric dialog options

Opening metric from the Element panel opens a dialog box with the following options:

1. Expression builder: You can create an arithmetic expression that makes use of various aggregations on the data.

2. Appearance: Allows setting of format, display title, subtitle and a note.

3. Conditional filtering: A condition can be set on the data before metrics is calculated.