Open Vs. Closed

[Mehernosh Amrol]

Hello,

I'm trying to create a report which shows tickets opened vs. closed for Months and also Years.  Any thoughts on what is the best way for this to be set up?

Thank you in advance.  I'm looking at the Engagement Table in GRC.

[Raj68]

HI,

Hope below link will help you:

https://community.servicenow.com/community?id=community_question&sys_id=a3bdc76ddb9cdbc01dcaf3231f961919

NOTE: Mark correct or helpful if it helps you.

 Warm Regards,

Raj patel

[Ruhi Jibhyenka1]

Hi mehernosh,

Refer to these links-

https://community.servicenow.com/community?id=community_question&sys_id=a3bdc76ddb9cdbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=4abb63fcdbc13f40fff8a345ca96...

https://community.servicenow.com/community?id=community_question&sys_id=ba5247eddb98dbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=0f2dc3a9db9cdbc01dcaf3231f96...

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy.

Thanks,

Ruhi.

[Mehernosh Amrol]

Thank you.  We are using London instance, and found that I had to switch to "Classic UI" to create the use the Multiple Data-set option. I think I also found a bug.  If I create and save the initial trend report, the Multiple Data set is LOCKED to the "PER" when the report was created. 

[Andrew_TND · Accepted solution]

Hi Mehernosh

Have you tried combining two different data sets?

For example creating your tickets created graph and then going to - 

Then creating your second, this would give you the results side by side on a time series graph.