Create and Manage Manual Metrics

Manual metrics can be

  • connected to more than one measure,

  • tracked independently from a measures (only live in Metric Library), and 

  • used for metric tree aggregations (sum of values, average of values) or related

This will benefit big time for business continuity and strategic governance by assessing the progress over time and allowing the stakeholders to review and reset.

Create a manual metric 

  1. In the Metrics > Library tab, click + Create new metric, and select Manually tracked option.

  2. Give the metric a name, unit and specify a trend. In case you do not find the unit you're looking for, you can input your own custom unit - just type it, click + Add "unit" as a new option, and it'll get added. 

  3. Click Save.

  4. In the Source data tab, select how your data needs to be set up (cumulative or non cumulative), the time frame and how you wish to display the data as (summed up, average of or just the last entered value).  

  5. Click Add values to add data points to the metric table and click Done

The Source data tab (Manual metrics only)

You can define how you wish to set up your manual metric from the Source data tab.

  • Raw tab displays the actual data points or values that you enter either manually from here or if connected to a measure, by scooting the progress bar manually in the measure.

  • Processed tab displays the processed data based on how you set up the data.

    For example, if you had entered data for every month in the Raw tab and chose Source data is Non cumulative, Time frame Quarterly, and the Total is Sum of values, then you'll see that the data is displayed as Quarterly in Date column and summation of actual values of each quarter in the Value column. Note that, in the screenshot below, though we have data till September 4th, since the current date is not past September 30, there is no entry for Q3.Data20set20up

If the data is entered "monthly" in the metric, and if the Time frame you choose is "quarterly", then the values are grouped and the data points are shown quarter-wise. For example, you've values from January to July, the metric tile will display

  • Summed up values from January till July, if "sum of values" is chosen. The "Processed" tab will show grouped values - March 31 (Q1): Sum of Jan to March; June 30 (Q2): Sum of Jan to June.

  • Average of values from January till July, if "average of values" is chosen. The "Processed" tab will show grouped values - March 31 (Q1): Average of Jan to March; June 30 (Q2): Average of Jan to June. 

  • Value in July month if "Last value" is chosen. The "Processed" tab will show - March 31 (Q1): Value of March; June 30 (Q2): Value of June.

The metrics will not display July values and Q3 values will be displayed only when the metrics has data till September and the present date is past September.

Some points to note:

  • If you select Cumulative in Source data is, then the Total is will automatically default to Last value, and you'll not be able to edit it.

  • Total is- the option that you choose here will decide the way the value is displayed, i.e., if you choose

    • Sum of values, then we'll add the values in the Value column, and display the summed up value for the time frame that you choose.

    • Avg (Average) of values, then we'll display the average of values in the Value column for the time frame that you choose. i.e., if you choose the timeframe as Quarterly, then the average of the values in those months of that quarter will be displayed.

    • Last value, then we'll just display the latest value available in the Value column for that metric. Remember that, any value entered against a future date will not be considered, and only that value which is available latest (as on the current date or before the current date) is displayed.

  • Time frame - depending on the frequency or time frame that you choose, the data will be displayed. Note that, selecting a time frame that is smaller than how you've entered data in the Raw tab show the same value over and over (i.e., selecting "daily" when the data is entered "monthly", will display the same value every day until the month changes, and so on).

If anything other than "daily" is chosen, the values that you enter in "Raw" tab will be processed and displayed either on the last date of the week or last date of the month (January 31) or last date of the quarter (March 31), or last date of half year (June 30), or last date of the year (Dec 31) depending on what you choose in Time frame - weekly, monthly, quarterly, biannually or annually.
If you wish to see the data against the exact date when you entered the actual value, then you need to choose "Daily" in Time frame.

  • Trend - depending on the trend that you choose, the color will change, i.e., if you choose "Higher is better" or "Lower is better", then when the metric value matches this criteria, the color will be green. If the metric value is opposite to the trend that's set, then the color will be red.

Edit/Delete Manual Metrics

All the metrics will be available in the Metrics > Library tab. Click the metric to view its information from the Sidebar. See Manage Existing Metrics via Sidebar

  • Details - Displays a line graph of the metrics data entered over time. Click Add values to enter data points to the table.

  • Measures - Here, you can either create a new measure from this metric, or you can view the measures that are connected with this metrics.

  • Table view - Displays the exact values of the metrics that you entered over time.



To delete, Click the three dots in the metric that you wish to delete - please note, this will permanently delete the metric from the library. If you wish to have it later, then you'll need to re-create it.


FAQs

Can we add historical data points to the manual metric?
Yes. If you wish to edit a value in the past or add some historical data point, click the metric name in the measure sidebar or toggle the Display manual metrics option in the Metrics library to access the relevant manual metric. You can then edit the metric from its sidebar and from the Source data tab - click the three dots against a value to edit it or click the + icon at the top right to add a data point.

Can I connect the same manual metric to different measures?
Yes, that's the main advantage of using metrics. But just remember that the same data points will be displayed across all those measures that are connected to it and if you do not need that then create a new manual metric.

I updated the progress on manual metric on 7th September, but the metric shows data points for August 31.
It is because you would have chosen Time frame as Monthly and the current date is still not past September 30. If you wish to see the actual value that you entered against the exact date, then choose Daily in Time frame.