Ticket Trend by month

Austin20
Tera Contributor

I'm trying to create a trend report between a year. I have it populating data but it's not starting at the correct date. The below parameters are what I am using. However, the first month displayed is May 2020. I've tried extending the opened after a couple more months but that didn't help. There are tickets between Jan - April 2020 that should display. I'm not sure what I am missing if someone could point me in the right direction please. Thank you!

find_real_file.png

 

find_real_file.png

1 ACCEPTED SOLUTION

Here is another option, your first dataset will be Last Year and the additional dataset will be This Year. When you build it like this with these filters, it will get rid of the Other column. Here is a ServiceNow doc that talks about Additional Datasets:

https://docs.servicenow.com/bundle/quebec-now-intelligence/page/use/reporting/concept/c_MultipleData...

find_real_file.png

find_real_file.png

Create another Dataset as well to attach to the report.  One dataset will be Last Year and one will be This Year.

find_real_file.png

This is what your additional dataset will look like:

find_real_file.png

 

View solution in original post

8 REPLIES 8

Thomas_Davis
Administrator
Administrator

 

Had the wrong response in the first reply, sorry.

Try using Opened Between 01/01/2020 00:00:01 and 04/31/2020 23:59:59

Thanks Thomas for the quick response. We were trying to gather stats for tickets before covid and since we have been working from home. It would be March 2020 to now is what I'm trying to gather. However my issue is that no more months are coming up even if I specify later dates like the beginning of the year. I'm missing March and April of 2020.

Try this:

find_real_file.png

Actually this:

find_real_file.png