Magic ETL Help
I am going through the Data specialist practical test and am running into troubles.
Here are my instructions:
Up to this point, this is what I have done:
Because I am not an admin on my company network, for those familiar to this test, I was unable to complete the join on the workbench due to accessibility issues. However, I was able to join them in ETL given my functionality.
I have come to the point where I have selected all the columns I need but am not sure how to calculate the average time between orders BY CUSTOMER. It makes sense to use the 'date operations' tile and ask for a subtraction from transaction dates but I am unsure (and it doesn't give me the correct output) how to do that same function and include the customer ID, which it seems to be asking.
Any help would be awesome. Pictures explaining would be much appreciated.
If this helps, feel free to agree, accept or awesome it!