Creating a line chart showing open vs closed

[Daniel O_Connor]

Hi all,

Figured this was a relatively straight forward thing to do, but really struggling to work it out. Want to create a line chart, with two lines. Showing Opened vs Closed per month for this year. Can't seem to figure out how to make this work, when I do get two lines to show it's not correct.

I'm using standard OOB reporting, do not have performance analytics 

[Nomava Ntaka · Accepted solution]

Hi Daniel

you can create 2 datasets - 1 for open and 1 for closed, trend on open one by opened per month and trend on closed one by Closed per month.

You will have to filter these data sets by statuses - Open (filter by everything in open state or active is true) etc.

please let me know if this makes sense.

Mava

[Daniel O_Connor]

When you say "create two datasets" not sure what you mean there?

All the records are in the Incident table, are you saying I need to create two datasets within the report? 

Here is where I'm at, at present with this

[DJL2]

Hi Daniel,

Yes, you’ll need to imbed another dataset in order to trend Closed on the same time series.

Select the button in the top right of your report, then Add Dataset. Design your Closed line graph, hit save and voila - both will render on the same chart.

[Daniel O_Connor]

Would you mind sharing a screenshot for this Add Dataset, unless I'm blind, I cannot see this in my UI