To define an indicator function based on cell values:
- From the Data Source dialog box, select the Cell Value option. The Graphical Calculation Area displays the Cell Value options.
- In the text box above the green segment, enter a low threshold value. Any number less than or equal to this number will be represented by the green star indicator. Any number greater than this number will be represented by the applicable yellow or red segment.
- In the text box above the red segment, enter a high threshold value. Any number greater than or equal to this number will be represented by the red circle indicator. Any number less than this number will be represented by the applicable yellow or green segment.
For example, with a category such as "Current Open Bugs", you may want to define that less than 40 open defects at this stage is good, between 40 and 90 is acceptable, and more than 90 open defects is cause for concern.Notes:
- The indicators shown (green, yellow, and red in this example) are those selected when hitting the "Functions Indicator Button", which, by default, are those selected by the Administrator for the system.
- In the example above, high values are red and low values are green. If the number entered in Step 0 is greater than the number entered in Step 3 high values will be green and low values will be red.
The rule is that all numbers entered should be ascending from left to right, or descending from left to right, but never mixed. If this rule is not followed, an error message will appear and the function will not be saved. - The direction of the flags shows which comparison is inclusive. In the above example, any number less or equal to 40 will be represented as green indicator; any number larger or equal to 90 will be represented as red. You cannot control the direction of the flags.