Use comparison value to compare a single day with a range?
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?
Tagged:
0