Line graphs and multiple group expressions

[DriftwoodProse]

I am working with a report and I'm having some trouble with two specific charts that I need to include.

The first, and most basic in my mind, is a line chart over time. The x-values are equal to a specific date and the y-values, the number of bugs found on that date. The trouble I'm having is that I need two lines, one for dateCreated and one for dateClosed. I can produce the two graphs individually simply by making the group by expression the corresponding date, however if I put both expressions as groups, it groups them together and produces a crazy graph. Is there a way that I can get both of these lines on one chart?

The second graph is very similar, it's just a cumulative graph, which I'm sure I can finish up as soon as I figure out the grouping issues I'm currently having.

 

[xlbo]

Your data is upsidedown - your data needs to look like:

Date QueriesOpened QueriesClosed
Date1 3 5
Date2 4 2

etc etc

It will never work if you have 2 seperate dates - you need 1 date and 2 numbers...same with the cumulative graph...should be able to do it from the same data set - just create an expression using RunningSum to get your YTD values from the individual dates

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question