Aggregated Value With Display Mapping Showing Unexpected Value
Article ID: 435307
Updated On:
Products
Issue/Introduction
When grouping by an attribute that has Display Mappings, the "summary" value that appears for all the referenced items does not match the expected value.
For example, a custom attribute showing status as "On Track" (Green) / "At Risk" (Yellow) / "Critical" (Red), when grouping by this attribute, the summary of three instances with an "On Track" (Green) value show as "At Risk" (Yellow).
Environment
Clarity 16.4.1
Cause
The attribute is defined as a Number attribute, and the display mappings work like this in our example:
- 0 - 30: On Track - Green
- 31-60: At Risk - Yellow
- 61-100: Critical - Red
The actual number for the attribute is calculated from a custom formula.
When grouping by a numeric attribute, the default summary value Aggregation Value is a "Sum", so the resulting value is the Sum of the values from the three instances.
If those instances had:
- 10 (On Track - Green)
- 15 (On Track - Green)
- 20 (On Track - Green)
Then the Sum of the three values is:
- 10+15+20 = 45 (At Risk - Yellow)
Resolution
Hover the mouse over the header row of the table on the attribute, and you will see a Hamburger menu. Select "Aggregated Value" and the operation that fits your specific use case (for example, 'Max' or 'Average', instead of 'Sum').
The Aggregation Value is performed quantitatively, mathematical (e.g.: with the example values and Average, ((10+15+20)/3)=15, On Track - Green), not qualitatively, the display mapping bucket (e.g.: Green + Green + Green / 3 = Green).
A new example: 9 "On Track - Green" instances with a value of 29, and 1 "At Risk - Yellow" instances with a value of 59, would average (29 x 9 + 59)/10 = 32, so it will display "At Risk - Yellow" even if there were 9 Green values and only 1 Yellow value.
Additional Information
Feedback
