Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: D1234 on 26 Dec 2017 12:58:59 PM

Title: Combining charts
Post by: D1234 on 26 Dec 2017 12:58:59 PM
Hello,

I have two separate queries in my report, both of which work and are exactly the same except for a filter which is slightly different between the two of them. Both reports return correct information. I have two separate correct charts. Is there a way in which I can combine the two charts (line graphs) into one chart? I have attempted using a join and a union but both have completely altered the numbers, resulting in an incorrect chart. Does anyone know of a simpler way to achieve this?

Thanks
Title: Re: Combining charts
Post by: MFGF on 27 Dec 2017 03:30:57 AM
Quote from: D1234 on 26 Dec 2017 12:58:59 PM
Hello,

I have two separate queries in my report, both of which work and are exactly the same except for a filter which is slightly different between the two of them. Both reports return correct information. I have two separate correct charts. Is there a way in which I can combine the two charts (line graphs) into one chart? I have attempted using a join and a union but both have completely altered the numbers, resulting in an incorrect chart. Does anyone know of a simpler way to achieve this?

Thanks

How about having a single query which uses a case statement or if-then-else in place of the filters (one condition for each line)?

MF.
Title: Re: Combining charts
Post by: Lynn on 27 Dec 2017 03:52:55 AM
Quote from: D1234 on 26 Dec 2017 12:58:59 PM
Hello,

I have two separate queries in my report, both of which work and are exactly the same except for a filter which is slightly different between the two of them. Both reports return correct information. I have two separate correct charts. Is there a way in which I can combine the two charts (line graphs) into one chart? I have attempted using a join and a union but both have completely altered the numbers, resulting in an incorrect chart. Does anyone know of a simpler way to achieve this?

Thanks

This post sounds similar to an earlier post although I'm not sure if they are the same question or not: http://www.cognoise.com/index.php/topic,34065.0.html

Title: Re: Combining charts
Post by: D1234 on 27 Dec 2017 08:07:04 AM
I can see if a single query is possible but will need to investigate that with regards to my data. Additionally, this post is a little different than my previous post. I had figured out some of the original issues I had in the other question I asked.

Thanks for the replies
Title: Re: Combining charts
Post by: Invisi on 03 Jan 2018 07:55:41 AM
Did MGFG's answer help you? Is this thread finished?
Text only | Text with Images