AnsweredAssumed Answered

CA PPM 15.1 Jasper Soft stacked bar?

Question asked by JMSnider on Jun 22, 2017
Latest reply on Jun 26, 2017 by JMSnider

An internal customer has asked my team to create a report that looks like this:


Customer Requested Report Example


We have created a sub object to the project object and in it are description {Cust Approval, Design Solution, etc}, Start date and end date. I have made a query that gives me data in this format:

Project IDDescriptionStart DateEnd Date
PRJ0001Cust ApprovalDec 15, 2016March 15, 2017
PRJ0002Design SolutionJan 1, 2017April 30, 2017
PRJ0002CODE SOLUTIONMay 1, 2017Aug 31, 2017
PRJ0002TESTSept 1, 2017Sept 30, 2017
PRJ0003PlanMarch 15, 2017July 15, 2017
PRJ0003Design SolutionJuly 16, 2017Feb 1, 2018


I have been hunting for an example to follow that will get me to this, but I am having a difficult time finding something helpful. I am not sure if I need to format my data differently, or maybe a simple easy to follow step-by-step would get me to the win. 

Help would be appreciated. 

Thank you,