Skip to main content
Version: 16.3 🔚

Achievement

Achievement is based on multiple indicators.

Achievement

There are 4 parts of an achievement,

  • Common time criteria,
  • Pre-defined indicators,
  • Computed indicators,
  • Total score.

Common Time Criteria​

Common Criteria

  • Define time criteria, which can be referred in pre-defined indicator. By year or By year + month is supported,
  • Define whether the previous period data should be applied or not. An increment ratio will be calculated automatically when previous period applied.

Pre-defined Indicator​

Pre-defined Indicator

All indicators pre-defined can be imported into achievement.

Naming & Criteria Apply​

Pre-defined Indicator 2

Click the criteria node, to

  • Define indicator name in this achievement,
  • Apply criteria into indicator,
    • year and month can be used in criteria value, which defined in common criteria,
    • Use pre-defined bucket to filter, or manually key-in.

Aggregation & Formula​

Pre-defined Indicator 3

  • Choose aggregation arithmetic,
  • Write formula which to compute score of this indicator.
info

Formula syntax is based on Javascript.

Supported Variables​

Variables are computed before compute score using formula,

  • c: value of indicator in current time period,
  • p: value of indicator in previous time period,
  • r: value of increment ratio.

Supported Math Functions​

All properties and methods on Math are supported. For example,

let x = abs(c); // assign aboslute value of current indicator value to variable x

And additional functions,

// when r is less than 0.1, returns 10
// when r is greater than 0.8, returns 50
// when r is between 0.1 and 0.8, returns 10 + (50 - 10) * (r - 0.1) / (0.8 - 0.1)
interpolation(r, 0.1, 10, 0.8, 50);
info

return keyword is not required when there is only one line of formula, otherwise use return to return the computed score.

Compute Indicator​

Compute Indicator

Compute indicators are designed for do manually calculation base on results of other indicators.

Formula​

Compute Indicator 2

Write formula which to compute score of this indicator.

info

Formula syntax is based on Javascript.

Supported Variables​

Variables from other indicators are supported,

  • v1, v2, ..., vn: n is index of other indicator, can be found at its result node,
  • v1.c: current value of v1,
  • v1.p: previous value of v1,
  • v1.r: increment value of v1,
  • v1.s: score value of v1,
  • and v2.c/v2.p/v2.r/v2.s ... vn.c/vn.p/vn.r/vn.s
caution

Be very careful,

  • circle dependencies may cause unpredicted result or error,
  • never use itself in formula.

Append or Remove indicator​

  • Append compute indicator by click Add Manual Compute Indicator,
  • Append pre-defined indicator by click leaf node of pre-defined indicators tree.

Add or Remove Indicator

And, remove existing indicator by hover its first node, and click the remove button,

  • Remove pre-defined indicator, Remove Indicator 1
  • Remove compute indicator, Remove Indicator 2

Total Score​

Finally, all computed scores are sum and show at root node of achievement.

Total Score

tip

Simply remove the check Include in Final Score of indicator score node to remove its score value from summary.