Search for 'this week'?

RT Users
1

I’d like to add a saved search/chart that displays the # of tickets Created
’this week’ and the number of tickets Resolved ‘this week’.

Is such a thing possible?

-Josh

2

I created saved searches:

“This Week’s Tickets” = Created > ‘Last Sunday’
“Last Week’s Tickets” = Created > ‘Sunday Before Last’ AND Created <
‘Last Sunday’
“Today’s Tickets” = Created > ‘Midnight’
“Yesterday’s Tickets” = Created > ‘midnight 1 days ago’ AND Created
< ‘midnight’

adding from there, you should be able to modify for Resolved, Owned by Me,
etc…

–stephenOn Thu, Apr 14, 2016 at 5:54 PM, Josh Tackitt tackittj@reed.edu wrote:

I’d like to add a saved search/chart that displays the # of tickets
Created ‘this week’ and the number of tickets Resolved ‘this week’.

Is such a thing possible?

-Josh

RT 4.4 and RTIR Training Sessions https://bestpractical.com/training

  • Washington DC - May 23 & 24, 2016

Stephen Dowdy - Systems Administrator - NCAR/RAL
303.497.2869 - sdowdy@ucar.edu - http://www.ral.ucar.edu/~sdowdy/

1 Like
3

Stephen Dowdy wrote:

I created saved searches:

“This Week’s Tickets” = Created > ‘Last Sunday’
“Last Week’s Tickets” = Created > ‘Sunday Before Last’ AND Created <
‘Last Sunday’
“Today’s Tickets” = Created > ‘Midnight’
“Yesterday’s Tickets” = Created > ‘midnight 1 days ago’ AND Created
< ‘midnight’

adding from there, you should be able to modify for Resolved, Owned by Me,
etc…

Hope you don’t put in tickets on Sunday or at midnight.
[Likely safe bet, but just in case…]

Query should be something like:
“This Week’s Tickets” = Created > ‘Last Sunday’
“Last Week’s Tickets” = Created > ‘Sunday Before Last’
AND Created <= ‘Last Sunday’
“Today’s Tickets” = Created > ‘Midnight’
“Yesterday’s Tickets” = Created > ‘midnight 1 days ago’
AND Created <= ‘midnight’

/jeff

The information contained in this e-mail is for the exclusive use of the
intended recipient(s) and may be confidential, proprietary, and/or
legally privileged. Inadvertent disclosure of this message does not
constitute a waiver of any privilege. If you receive this message in
error, please do not directly or indirectly use, print, copy, forward,
or disclose any part of this message. Please also delete this e-mail
and all copies and notify the sender. Thank you.

For alternate languages please go to http://bayerdisclaimer.bayerweb.com

1 Like