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

Date Range filter

edited Sep 16, 2019 11:04AM in Reporting & Analytics for B2C Service 2 comments

Summary

Search a date period between two dates but only display times on output between a set time.

Content

Hi hope you can help.

I have set up a cross tab report which groups the data I need by day and hour and displays the data by day and hour. This displays perfect if my date range search is set for a particular day between the hours I want it to display which is between 9am - 6pm.

If I expand my search date range to more than 1 day my output displays the times outside of the above hours. Is there a way of not showing these times in my output as there will never be any data outside of 9am and 6pm to present?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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