I am new to in QV world and trying to put together a small analytics dashboard. I am trying to count records (activities) created by different users and to group them by 5 minutes period starting 2009-01-01 00:00:00, for each user and each activity. In the code below I am using just one activity for testing. The records get counted and grouped by user but I cannot get them grouped by 5 minute slots.
Please advise. (qvd enclosed)
[Note Created By]as CreatedBy,
'Note Created' as Activity,
Interval(([Note Created On] - '2009-01-01 00:00:00')/300,'S') as CreatedOn_SSDiff,
[Note Created On] as StartingDate
Min(Date(StartingDate,'YYYY-MM-DD hh:mm:ss')) as SD,