Simple day average from 2 fact rows aggregated by order
Hello guys, I have a simple question about calculating average date diff (in days) between two facts of the same order.
Here is a sample data:
The result should be 4,4. I think I should use Aggr by Order Id but I don't know how to calculate the delta using the 2 Fact Types (SENT and DELIVERED).
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.