Context - running a report on caseHistory object, where data is grouped by caseId (ascending) and then Date/time difference of CreatedDate and previous rows CreatedDate has to be captured at each row
I am trying to execute below code as computeRelative Transformation in Einstein Data Analytics (or Wave)
Have tried to work with this date field from last 6 hours but not able to figure hoe to find the difference between two date fields , the first one comes from the row and the other one comes from previous row. Please note that this works absolutely fine in SAQL query but I am trying to execute this in the data flow. I suspect we cannot do this undless data "registers" (sfdcRegister).
Help appreciated. happy holidays.