Working With Metrics

Operation on Metrics

Save Data to Sheet

1. To save data, the metric should be of input type. Navigate to the metric and enter data as you would in Excel, or paste values from a source.

2. Click Save to save the input. A dialog will display the number of records updated.

View and Order Metric List

This feature enables changing the sequence of appearance of metrics. Follow the steps below to reorder metrics:

1. Go to the metric page and drag metrics into the desired order.

2. On the level 2 header, click Save to save the sequence. This order will now reflect in the sheet.

Delete Metric

1. To delete a metric, go to the metric page and check the box to the left of the metric(s) to be deleted.

2. On the level 2 header, click the Bin icon.

3. In the popup, type in the name of the metric exactly as it is and click Okay. This will delete the metric.

Export Metrics

1. Click on the App name from the Explorer pane and go to the Metrics tab.

2. From the level 2 header, click the Ellipsis button and select Export. The file will start to download.

Re-calculate Metrics

1. Click on the App name from the Explorer pane and go to the Metrics tab.

2. From the level 2 header, click the Ellipsis button and select Re-Calculate metrics. The recalculate metrics details will open to the right.

3. Select Version and Time members. Version is a single selection, while Time can have multiple members.

4. Click Calculate at the bottom. The recalculation log will be displayed.

v25.06:  Natural Sorting in Metric Dropdowns

To enhance usability and reduce time spent searching, a natural sorting logic is implemented in all metric dropdowns across the platform. This update ensures a consistent, intuitive order for metric values, improving both navigation and filtering efficiency.

The dropdowns now follow a natural sort order every time they are loaded, refreshed, or filtered. The Autocomplete and search results also follow the same natural sort order. Sorting remains consistent even after adding, editing, or deleting metrics.

• Numeric Metrics First
  Metrics with purely numeric names (e.g., 1, 23, 110) appear at the top, sorted by their actual numeric value rather than as text.
  Example: 1, 23, 110, 456

• Alphabetic/Alphanumeric Metrics Next
  Metrics containing letters (e.g., Revenue, A1, Actuals2023) follow numeric metrics, sorted alphabetically in a case-insensitive manner.
  Example: A1, Actuals2023, Revenue, Target

• Blank or Null Values Last
  Any metrics with blank or null names are always placed at the end of the list.

  The case-insensitive sorting ensures Metric 1 and metric 1 appear together. Alphanumeric values (e.g., A1, B10) are sorted within the alphabetic group. The sorting is deterministic, ensuring there is no randomness or variation when the dropdown is reloaded.

This enhancement aligns with enterprise UI standards and significantly improves the user experience when interacting with metric dropdowns.