I'm a noobie, and I have an issue that I can't seem to resolve after more hours spent than I'd like to admit. I have a situation in my chart (
# Transactions - Rolling Count vs Day Comparison ) where I'm trying to take an average count across a date range and compare that to a single day for trending. To better explain I want an average count of transactions for the first two weeks of the month vs the count for the last day of the month, but across a time drill through group year, month, day, hour. Right now it looks ok at the month level, but as soon as I drill down it shows the overall total, because that's what I'm asking for but I need to show the average transactions for those hours and not the total.
I'd appreciate any help or suggestions as I'm truly stuck at this point!
