How to run a report based on a day of the week by a time range

Terry S
Kilo Explorer

‎11-19-2018 11:13 AM

Hi,

I've been trying to figure out how to run a report based on a specific day of the week and within a time range but can't seem to make it happen.

For example I'd like to run a report to see how many tickets were Created on Mondays between 8-9am over the course of a month or a year.  I can't seem to figure out how to make it be that specific and generate results using the Reports/Run feature with whatever variables I put in there.  Help please!

 

 

0 Helpfuls
  • 6,767 Views
6 REPLIES 6

Uncle Rob
Kilo Patron

‎11-19-2018 01:49 PM

The secret is in the TREND operator.  Here's the criteria you'll need (minus the hard start / end dates for the range you're querying).

find_real_file.png

 

Smash that helpful / correct answer like the first of an angry god.

Preview file
25 KB

Uncle Rob
Kilo Patron
In response to Uncle Rob

‎06-24-2019 01:59 PM

Since this question comes up once in a while, I thought I'd crank out a small video on Trend.

Ronak3
Tera Contributor
In response to Uncle Rob

‎07-20-2020 06:48 PM

Hello Robert,

Can you let me know if we can run a weekly report starting from Wednesday to Tuesday ? Is it possible with OOTB conditions? Or any schedule job or script include is required ??

0 Helpfuls

Uncle Rob
Kilo Patron
In response to Ronak3

‎07-21-2020 01:30 AM

Gotta be more precise.
If its run on a MOnday, does it show "UPCOMING wednesday to next tuesday"
Run on Tuesday, show "UPCOMING wednesday to next tuesday"
Run on Wednesday, show "TODAY to next tuesday"?
What happens on thursday, friday, saturday, and sunday runs of this report.


Probably a good idea to start another thread.

0 Helpfuls