I'm trying to calculate the time difference between API calls but also group them by requestID and day. So far, I have the following Beast Mode to reformat my `requestTime` into time and tell the difference. Meanwhile, I'm trying to use the card itself to group by requestID and date. Currently nothing is coming back.
Any suggestions to do this either in a card, Beast Mode or MySQL is greatly appreciated. (The simple TIME function didn't seem to format correctly.)
TIMEDIFF(MIN(TIME_FORMAT(SUBSTRING(`requestTime`,13,8),'%h:%i:%s')),MAX(TIME_FORMAT(SUBSTRING(`requestTime`,13,8),'%h:%i:%s')))
requestTime format example:
22/Oct/2018:20:22:24 +0000