Using multi-row, shouldn't the following give the number of minutes between records? (column with datetime is named DateTime - just to state the obvious)
DateTimeDiff([Row-1: DateTime],[ DateTime],'minutes')
I just get a null or a zero (if it's the same time) I don't get the minutes between the records.
Solved! Go to Solution.
Hi @Watermark
You're probably checking the Group By box.
Uncheck it and it might work.
Otherwise please pump us some data.
Cheers,
Yep, group by, got rid of it, and getting result I expected
User | Count |
---|---|
19 | |
15 | |
15 | |
9 | |
8 |