Combining charts

[D1234]

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

[MFGF]

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.

[Lynn]

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

[D1234]

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

[Invisi]

Did MGFG's answer help you? Is this thread finished?