can someone please help me for this question of magic etl

Magic ETL Activity
Using the DataSet in Domo you created using Workbench in the previous activity,
1. Use Magic ETL to parse the currency code from the "Transaction Amount" column and separate the amount and the currency code into separate columns.
Submit: A screenshot of the output of the data showing the different columns created.
2. Calculate the average time between orders. For each record in the DataSet, add a field showing the number of days since the previous order for that customer.
Submit: A screenshot of which customer has the longest average time between orders and what is the average number of days?
so this is my practical quiz, I have no experience in this but i got a job as business intelligence and I have to finish this course, I have no problem with questions number 1 it is questions number I am very confused about.
this is how I do so far, I use the rank window to create the rank and another to Calculate the average time between orders. honestly, I don't know if I'm doing this correctly, can someone please let me know if what I did is correct? please? also how can I show which customer has the longest average time between orders and what is the average number of days?
Answers
-
i got questions for number 2 please anyone im so frustrate i search everywhere i cant understand
0 -
To see the time between orders for a customer you can use the rank and window tile with a lag function. Order by order date and partition on customer ID. Let me know if you are still stuck!
If I solved your problem, please select "yes" above
0 -
@fadhlirrahman , For #2, I would investigate the rank & window tile. You must classify the 1,2,3,4,etc. order ranking for each customer ID. From there you can take the difference of days using date operations between the orders to then avg. I hesitate explicitly laying the answer out through snapshots as this is for certification, but this will definitely get you started in the right direction. :)
IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU! 😎😎😎
0 -
Hi it is solved, thank you
0 -
-
i have managed to get the average time, it looked like this. but now im wondering on how to get A screenshot of which customer has the longest average time between orders and what is the average number of days?
do i use group by?
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 437 Beast Mode
- 23 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive