Hi Prantika,
Thank you for your reply! I was able to create the lag function.
When trying to create a calculated field for the date difference between the non-lagged timestamp and the lag timestamp, it gave me a mismatched aggregation error. I came across this post, and “aggregated” the non-lagged timestamp following Dylan’s suggestion, and it worked for my table.
The next roadblock was when trying to get the average date difference for the large categories, I wasn’t able to create the calculation - “nested aggregation functions are not allowed”.
Is there somehow a way to get the Avg Diff numbers in the scenario below?
