Ask Magic ETL questions and get answers from Domo peers
Hoping others feel this way and it gains some traction? I know it's trivial, but still….
Hello, currently I have the standard recursive flow set up in the magic ETL, which tile and where in the recursive dataflow should I add to get the current date of when a new row gets added to the dataset?
Question: I have two separate databases where there is only one common column, which is the "salesperson." The first database contains sales values for each salesperson. The second database contains the area of operation and products associated with each salesperson. I plan to create a new column to calculate the…
I currently have a recursive magic etl set up to 'screenshot' data that is different from the source data. This information has been helpful because we can see the historical data any time a row in a column is changed. Like keeping a data log of all changes. However, I need to add a timestamp each time the recursive magic…
I am trying this code but still cannot get data from previous month from last year 2024. All I got in "Past Due" is data from current month (January) and in "Future" I get all the data from future month plus from last year CASE WHEN MONTH(`SSD`)<=MONTH(CURRENT_DATE())AND YEAR(`SSD`)<=YEAR(CURRENT_DATE()) THEN 'Past Due'…
I have two datasets: one for home country and another for citizenship. Both datasets share two common columns: country and student_id. In the home country dataset, the country column is 70% populated, leaving 30% of the rows as null. I want to fill these null values in the home country dataset using the corresponding…
Lunar New Year is tomorrow and I made an Asian Zodiac calculator last night using Domo ETL, Domo Dimensions and Domo App Studio. I am very curious about everyone's Yin/Yang Animal Element sign. Please enter yours I am a Yin Fire Cat - Feels purrfect.
i need to split a column that has 20250115 into 4 digit year 2 digit month and 2 digit day, or how to convert to date formula to give me a date in this column
Hi I'm really struggling with my dataset as I have a many to one relationship between the DIVISION and CUSTOMER columns which causes issue with grouping later in the ETL How do I write a formula which will affix the Customer name with the Division name if the customer appears against 2 or more Divisions else if the…
Hi All, I have a beast mode created as CONCAT(YEAR(`pickupDATE`),'-',MONTHNAME(`pickupDATE`)) which in turn returns values such as 2020-April, 2020-june and so on...When I try to display this as a quick filter I get the values displayed in the quick filter in my card in random order -such as 2020-April 2020-August…
It looks like you're new here. Sign in or register to get started.
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Ask questions about Jupyter Workspaces, R & Python Tiles, AutoML and get best practices from Domo peers
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Watch how our Customers are using Domo to solve their complex problems.
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Questions or discussions related to Domo University, trainings and certifications