SOLVED
Minutes between records
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
12 - Quasar
‎07-15-2019
02:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Date Time
2 REPLIES 2
17 - Castor
‎07-15-2019
02:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Watermark
You're probably checking the Group By box.
Uncheck it and it might work.
Otherwise please pump us some data.
Cheers,
‎07-15-2019
02:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yep, group by, got rid of it, and getting result I expected
