-
time on both col and rows
I'd like a report with days across the top and 24 hours down the rows so management can compare call data performance hour to hour across days.
select
{ [TimeByMinute].[All TimeByMinute].[2005].[May].[1] : [TimeByMinute].[All TimeByMinute].[2005].[May].[10] } on columns ,
{lastperiods(24, [TimeByMinute].[All TimeByMinute].[2005].[May].[1].[23])} on rows
from ACD_Calls2
where [Measures].[Calls]
I get the "duplicate dimensions across (independant) axes" message.
Any ideas?
Richard
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|