Graph Portlet in Classic does not show correct Legend when using Consistent colors

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When creating a Graph portlet with a stacked bar with the data and Consistent Chart Colors enabled for portlet, the legend does not show the correct colors to match the graph

 

STEPS TO REPRODUCE:

1. Connect to Clarity 16.3.0 – Administration – System Settings and make sure Use Consistent Chart Colors is enabled
2. In Classic, create a new project, note the internal ID
3. Open the Project – go in Tasks
4. Create new tasks with TaskIDs as follows:
   
   • Task ID
     scoping
     leadership_appr
     inqueue
     predesign
     design
     const_docs
     plan_check
     bid
     construction
     fitup
     licensing
     movein
     closeout
5. Now go to Administration – Queries and create a new query as follows (replace the internal ID with the project internal ID you noted in step 2):

SELECT 
--DIM 1
@SELECT:DIM:USER_DEF:IMPLIED:PRJ:P.ODF_PK:PRJINTID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.NAME:PRJNAME@,
--DIM 2
@SELECT:DIM:USER_DEF:IMPLIED:TASK:T.PRID:TASKID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:TASK:T.PRNAME:TASKNAME@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:TASK:T.PRWBSSEQUENCE:SORTORDER@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:TASK:100-T.PRWBSSEQUENCE:ALTSORTORDER@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:TASK:CASE t.prexternalid WHEN 'scoping' THEN 12
                                 WHEN 'leadership_appr' THEN 14
                                 WHEN 'inqueue' THEN 12
                                 WHEN 'predesign' THEN 5
                                 WHEN 'design' THEN 1
                                 WHEN 'const_docs' THEN 1
                                 WHEN 'plan_check' THEN 0
                                 WHEN 'bid' THEN 2
                                 WHEN 'construction' THEN 15
                                 WHEN 'fitup' THEN 3
                                 WHEN 'licensing' THEN 4
                                 WHEN 'movein' THEN 3 
                                 WHEN 'closeout' THEN 17 ELSE T.PRWBSSEQUENCE+6 END:DISPCOLOR@,
--METRIC
@SELECT:METRIC:USER_DEF:IMPLIED:T.PRDURATION:TASKDURATION@
FROM PRTASK T
INNER JOIN ODF_PROJECT_V2 P ON P.ODF_PK = T.PRPROJECTID
AND P.ODF_PK = 5005004
WHERE    @FILTER@

6. Go to Portlets – create New Chart Portlet
7. Select the above Query as Data Provider

• • Base Size = Small
  • Set Chart Type = Bar
  • In Source Data: for Y Axis set PRJ
  • In Options (note you have to save after each change):
  • Show Legend – Set to Enabled
  • SubType Stacked
  • Legend Labels = Taskname
  • Use Consistent Colors = Yes

8. After completing the setup Save the portlet
9. Go to Clarity General Overview – add a new Tab
10. Add the new portlet to the content and view it

Expected Results: The portlet to have Legend colors that show the correct corresponding colors

Actual Results: The Legend colors do not match the Bar graph colors

 

Environment

Clarity 16.2.3, 16.3.0, 16.3.1

Cause

DE158136

Resolution

• Fixed in Clarity 16.3.2
• Targeted in Clarity 16.2.3 Patch 2 (16.2.3.3)

Workaround: Set Use Consistent Colors = No - this would help show matching Legend colors however will not use the Consistent colors feature which is required