Print Page - Creating a stacked bar using data of 5 columns of the same row

Title: Creating a stacked bar using data of 5 columns of the same row
Post by: navyadav on 15 Dec 2016 06:45:53 AM

I am using DB2 as my source for data and the data looks as shown in the attachment named TabularData.

What I need is to create a stacked bar in the report studio where the last column that is TotalIterations is the value of the full bar and the other columns related to the ticket are the stacks of the bar. Can somebody tell me how this would be possible ?

(http://tabulardata.png)

Title: Re: Creating a stacked bar using data of 5 columns of the same row
Post by: hespora on 16 Dec 2016 02:48:44 AM

See the attachment for the how-to.

However, I can't just *not* address the elephant in the room: You do realize that the numbers you are providing do not add up to TotalIterations, and thus, the stacked columns cannot match, right?

Title: Re: Creating a stacked bar using data of 5 columns of the same row
Post by: navyadav on 19 Dec 2016 01:30:38 AM

Well I did not provide the whole data so the numbers might not be adding up. Thank you for the help. :D

Title: Re: Creating a stacked bar using data of 5 columns of the same row
Post by: hespora on 19 Dec 2016 02:23:54 AM

sure thing, glad I could help!

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: navyadav on 15 Dec 2016 06:45:53 AM