Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can I control the time element of a "Between" filter

edited Oct 17, 2017 6:37PM in Reporting & Analytics for B2C Service 6 comments

Content

Hi All,

New to custom reports, but I am starting simple.  I am working on reports to simply show an incident count of tickets opened in our queue by month, and then one for tickets closed by month.  I am using filters to allow selection of queue, group by month/year, and want to add one that allows me to pick the date range.  The date range filter is giving me the problem.

When I add the filter for "between" it automatically sets the date and time to my system date.  The time is causing the problem when I run my reports.  I can choose my date range just fine, but I can not seem to control the time and this causes errors in my results.  E.g.  If my system time was 11:30am when I created the filter, it will always use that time regardless of date I choose.  If I want to count tickets opened/closed on the selected date the time matters and some tickets may not get included if they are

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!