question Re: Incidents created 3,4 or 5 days ago in Platform Analytics forum

Incidents created 3,4 or 5 days ago

troyjohnson — Tue, 02 Apr 2019 20:15:07 GMT

We're trying to pull reports of all incidents opened 3 days, or 4 days, or 5 days ago and using relative doesn't provide us with any data. Using "Between" doesn't provide us with the options we're looking for.

We're currently on the Kingston release.

Also...the new UI is terrible. You can't specify any filters on it. Is there something I'm missing on that?

Thank you!

Re: Incidents created 3,4 or 5 days ago

Prateek kumar — Tue, 02 Apr 2019 20:19:01 GMT

so you are wanting the incidents created 5days ago??

or between 3days ago and 5days ago?

Re: Incidents created 3,4 or 5 days ago

troyjohnson — Tue, 02 Apr 2019 20:30:58 GMT

3 separate reports. One for 3 days ago. One for 4 days ago. One for 5 days ago. "Between" doesn't work because of the limited options.

Re: Incidents created 3,4 or 5 days ago

Prateek kumar — Tue, 02 Apr 2019 20:35:33 GMT

How about a filter like this

Re: Incidents created 3,4 or 5 days ago

troyjohnson — Tue, 02 Apr 2019 20:40:15 GMT

That doesn't return any information. The "Relative" option will go back *exactly* 3 days ago, to the exact time you run the report.

Re: Incidents created 3,4 or 5 days ago

Allen Andreas — Tue, 02 Apr 2019 20:53:44 GMT

Unfortunately, date fields prohibit the use of javascript, which would allow you to tap into a script include...which you'd use to query for the gs.daysAgo(3); etc...so...here's a bit of a "wacky" way to get it to work...look at this thread:

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

Please mark reply as Helpful/Correct, if applicable. Thanks!

Re: Incidents created 3,4 or 5 days ago

noorulainatta21 — Fri, 31 May 2024 20:42:25 GMT

Hi,
To make at once a 3 to 5-day report, you can use this filter.

If you want to take one day's report try the following filter.

I hope it will help. Thumbs up if it's helpful.

Thank You,