I would like to find a Time Stamp difference in CRM analytics , Don't know how to execute that . Is there any way to find time difference of same field from two different row as shown in Screenshot .
When Status change i need to find how much time in mint it takes to status change for schedule to enroute and enroute to processing or so on .
2 个回答
There are two options to achieve this in general:
- use a multirow formula in a recipe
- use a windowing function (change from previous) in a query
Tip: use the Date_sec_epoch field to calculate the seconds, then divide by 60 to get the minutes.
