I know this should be easy, but I am having difficulty creating a new column during my load that calculated the difference between two timestamps in minutes
My current load statement looks like this
interval(Timestamp( CC_NOTIFICATION)) - Interval( Timestamp( EVENT_START))as [Event Start to CC Notified Minutes],
Results In this example, I'm looking for 157
| Event Start | CC Notification | Incident Start - CC Notified hh:mm | Result formated as a time using mm | Result formated as a number | Looking for |
| 12/13/18 8:00 | 12/13/18 10:37 | 02:37 | 01 | 0.109027778 | 157 |
