Activity status light
Scores one kind of data table and turns the result into a traffic light on the activity box. Keyed on the data table's *definition* rather than on the attachment. A data table attachment carries three identifiers and only one of them is shared: `id` is this activity's own copy of the table, `mxKey` is its index on that activity (which is 1 on every activity that has one table, so it looks shared when it is not), and `dataStructureDefinition` is the definition - the set of columns. Two activities carrying the same table share the third and only the third, so a mapping written once against it applies to all of them, and each is scored from its own rows.
Reached from Activity status lights on Viewer configuration.
Settings
Name
What this light measures, shown when a reader clicks it. For example "Customer satisfaction".
Data structure definition IDRequired
Id of the data table definition in Elements.cloud - the dataStructureDefinition on the attachment. Every activity carrying a table of this kind gets a light, scored from its own rows.
ColumnRequired
Name of the column within that definition to score. It has to hold numbers: an activity whose table has no such column, or whose column holds no numbers, gets no light rather than a grey one.
Measure
Latest takes the value in the last row of the table; Average takes the mean of every row that holds a number.
Latest— The value in the last row of the table.Average— The mean of every row that holds a number.
Higher is better
On for a figure where more is better, such as on-time delivery. Off for one where less is, such as open defects - the two thresholds below then read the other way round.
Green threshold
At or beyond this value the light is green.
Amber threshold
Between this and the green threshold the light is amber; beyond it, red. Two boundaries rather than three bands on purpose - three can be configured to overlap or to leave a gap, and a value landing in the gap has no answer.
Generated from CtrlProcesses 1.26.9.14.