Donut or Pie Chart Portlet Not rendering correctly using Boolean data type in Source Data Metric
book
Article ID: 130192
calendar_today
Updated On:
Products
Clarity PPM SaaSClarity PPM On Premise
Issue/Introduction
Donut or Pie Chart Portlet Not rendering correctly using Boolean data type in Source Data Metric
Environment
Release: Component: ODSTU
Cause
STEPS TO REPRODUCE
1. Create chart type donut portlet using Application object. 2. Chart Type = Donut 3. Source Data Metric = Active 4. Under Options a) Group By Column = Category b) Group By Function = Count c) Legend Labels = Category d) Datapoint Labels = Label and Value 5. Place this portlet on the General Page by creating custom tab 6. Notice that numbers are wrong for some Categories
Expected Results: Numbers for each category should match
Actual Results: Numbers are wrong for some Categories
Resolution
Defect DE48415, Fixed in 15.6.1
Workaround: Create a calculated attribute for the Boolean field. Create the attribute simply using Absolute(is_Active). Then use this attribute instead of the Boolean attribute in the Chart configuration and it works as expected.