Best Of
Re: Dataset Tabs appear to be hidden for some datasets
Those tabs become inaccessible if the dataset hasn't been accessed in a while. If you scroll all the way down you should see the option to reactivate the full functionality of the dataset:
jessdoe
Re: How do I set up multiple case statement for required field?
CASE WHEN `Oct ‘23 Required` = ‘yes’ AND `OCT ‘23` IS NULL THEN ‘Incomplete’ ELSE `Oct ‘23` END
Re: Exclude current month from Card
+1 for LAST_DAY. An alternative is:
CASE WHEN LAST_DAY(`Date`) < LAST_DAY(CURRENT_DATE()) THEN 'In' ELSE 'Out' END
Re: I want to host a webinar on how to automate all manual uploads into DOMO
VERY INTERESTED! @Mitch_Umbrellabi are you in the Slack community as well? I think lots of people would be interested in there as well.
Here's a link if you want to join:
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?


