Ask Magic ETL questions and get answers from Domo peers
Hi all, I have a 1.5 million row table that has been used many times over. For some reason, when I went to use it this morning, it was not wanting to work. I have a 'Bankruptcy Date' column that I feel pretty confident only has dates in it. I get this error code when I try to run this dataset through a dataflow. I cannot…
How do I sum a measure (activities) specifically for last week (Monday - Sunday) within ETL? I also would want to do for the week before. For context, my ultimate goal is to take an existing formula in ETL showing total potential activities for the week (which is constant) and then subtract the actual activities for the…
Hi, I have a question concerning how to fix an issue I am having when attempting to sum daily averages. Here is the issue that I have. As you can see in the image below. I have dates, IDs, and a daily average amount, set up in a dataset in my etl. In this sample, there are a total of 2 distinct IDs, the way I would like…
I have various start and end dates for campaigns. I know how to calculate the # of days between any get set of dates. But, what I am trying to set up in the etl is this - if I have a budget amount, start date and end date, what is the easiest way for me to have the etl calculate the division of the budget over the given…
I'm trying to extract the substring from an URL. URL: www.ab.com/level1/level2 I'm looking taking the level2 out of URL. What is the beast mode formula I can use here? I want to get: level2
I have a 1 million row dataset in Domo. I want to filter the data, and only export that data in a CSV. When I filter the data and export, Domo exports the whole 1 million rows, which does not run on my Excel. Anyone know how I can download the filtered dataset>
Hello, I am trying to subtract current week values with previous week values and have the ability for this to update each week. How would I do this in Magic ETL? A lag function? So 5-19 week would subtract from 5-12 week and then next week I would like to see 5-26 week subtract from 5-19. Thanks, Garrett
Hi all, I have a column that either has 7 or 8 digits in it. I need it to have exactly 10 everytime I am working in magic ETL and am wondering how I can create logic to see if the column has 7 or 8 then add 2 or 3 leading 0s to the column depending on which case is true. Any suggestions?
When you're performing calculations over 100s of millions or records sometimes you come across division by zeros in which you're hoping the software you're using would manage accordingly, I ran into a scenario in an ETL scenario where it lead to having more than a 10% revenue shortfall in my numbers. Generally in Domo if…
Hello everyone. I have a data set that looks like this: This data set shows product purchases at the customer level. Thus, product IDs are duplicated in the data set. Here's the challenge. I want to show the total value of products, counting each product value only once in a SUM. I've added a Product Rank column as a…
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