The CreatorCon Call for Content is officially open! Get started here.

Creating a line chart showing open vs closed

Daniel O_Connor
Kilo Guru

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 

1 ACCEPTED SOLUTION

Nomava Ntaka
Giga Expert

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

View solution in original post

10 REPLIES 10

Thanks, me being blind, never saw that option before 🙂