1 of 1 people found this helpful
Sounds like you want a busy dashboard. This should help if i am understanding you correctly.
Incidents opened within the past 4 days:
Incidents which have a creation date that is 5 - 9 days old:
Incidents which have a creation date that is 10 - 14 days old:
Etc... Play with the numbers to make sure you get exactly the days you want. I think what i have down might have overlap or might miss a day, so check, check, and triple check the results.
forgot to mention your first query has a strange criteria if you are trying to find a ticket which was created in the past:
I was able to write the first one using the following criteria:
Lifecycle equal to (Process)
Status.Is End is Equal to (False)
Creation Date Is Within the Next (4 days)
Within the Next (4 days) would indicate you are pulling data from whatever the current date is.
Just a thought.
or... he's looking for future tickets.
Now THAT's proactive service.
Oops - typo on the post... meant I used Creation Date is Within the Previous (4 Days)...
Thanks so much for the help on the other reply -- worked like a charm!! And yes... a very busy dashboard, but for my boss...