How to Set Up a Metric in KPI Fire

Configuration Options:

  • Data Input Frequency
  • Data Input Method
  • Pareto List
  • Metric Update Reminder
  • View Type
  • Data Mode
  • Date Range
  • Direction
  • Format
  • Decimals
  • Actual, Target, Begin Green Zone, Begin Yellow Zone, Begin Red Zone

Data Input Frequency

Select an input frequency that best matches how often the data will be recorded. Metrics require the same input frequency when creating parent/submetric relationships in order to enable data roll-up. View type options are limited by the frequency input; cannot select a view type smaller than the input frequency.

  • Hourly: 24 entries per day
  • Daily: 28-31 entries per month
  • Weekly: 52-53 entries per year
  • Monthly: 12 entries per year
  • Quarterly: 4 entries per year
  • Yearly: 1 entry per year

The data table will adjust based on the input frequency selected in order to enter data. To view the data in different intervals toggle the view type.

Data Input Method

Note: In order to roll-up sub metric data, all metrics must have the same data input frequency.

  • Manual: for manual input or api input
  • Sum sub metric data: Calculate this metric by summing specified metrics
  • Ratio: Calculate this metric by dividing one metric by another metric
  • Sum Project Benefit Account: Calculate this metric from specified project benefit accounts. (Must be monthly frequency)

Pareto List

Choose an existing Pareto list to enable reason code selection in the data table. Pareto lists can be created and managed from the settings area.

Pareto charts rely on data in the “reason code” column to display.

Metric Update Reminder

Check “Remind Me” to show this metric on the user’s daily update page when the metric due date has arrived or is past due.

View Type

  • Hourly, Daily, Weekly, Monthly, Quarterly, Yearly, 5 Year

Select a view type to toggle how the data is displayed in the charts and data tabs. Data is only editable when the view type selected is the same as the data input frequency. View types are limited by the input frequency of the metric; example: a monthly input frequency cannot be displayed in a daily view.

Data Mode

  • Sum (Through current period), Sum (All periods), Average, Most Recent

The data mode affects calculations represented in the charts tab and how data will roll-up if the view type is larger than the input frequency.

Date Range

  • Toggles the data being displayed for the metric based on the date selected

Direction

Status color for data is determined by direction selection.

  • > Bigger is Better  – Use for metrics like Revenue or Productivity.
  • < Smaller is Better – Use for metrics where smaller numbers are better like accidents/injuries.
  • = Control Chart: Use when a middle zone is best, or when tracking a process performance. (more info)

Example: Actual: 50, Target: 100

  • > Bigger is Better: Status = Red
  • < Smaller is Better: Status = Green

Format

  • # Number, % Percentage, $ Currency
  • Decimals

Formatting will affect how the metric’s data is displayed in the data table, charts, and all views.

Data Table

  • Actual – real values that are recorded
  • Target – forecasted value that is calculated against the actual to determine % of totals
  • Begin Green Zone, Begin Yellow Zone, Begin Red Zone – begin zone values are used to set ranges for the three zones of status color indicators

Note: If only red/green indicators are desired, then only use the actual and target values

How are Percent Complete Calculations determined?

  • Bigger is Better  % complete = Actual / Target
  • Smaller is Better   % complete = (Actual – Begin Red) / (Target – Begin Red)

Link a Metric
Use the Actions drop down to Add/Edit linked Metrics. The metric open can be converted into a parent metric that takes its data from linked sub metrics using the data input method options.


More Information on Metrics: