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

Use comparison value to compare a single day with a range?

edited Jun 28, 2017 2:14PM in Reporting & Analytics for B2C Service 2 comments

Content

Hi,

I'd like to make a report that compares the number of chats in each 1 hour interval of a day, with the average number of chats in the same intervals of the previous x number of equivalent days.

For example, if I run the report for yesterday I would like it to show me how many chats happened in each interval of the day, and the comparison to show me the average number of chats that arrive in the same intervals of the past 6 Tuesdays.

I've been playing with the computed columns and they only seem to compare to a single day. Is what I'd like to do achievable or do I have to do it in Excel?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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