Ask Magic ETL questions and get answers from Domo peers
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…
Hello, I am trying to work out a logic to forward fill values. Below is an example of what I want to achieve: I want to forward fill the Calculation column values and the grouping will be based on platform and code. So, I want to populate last non null value instead of zero in the calculation column. So, the output then…
I need to create a goal line dynamically on a bar chart. I have used scale marker in properties, but it is giving a static line. Can someone please suggest how can we achieve dynamic goal line. Thanks
Hi Everyone, I have a dataset with a monthYear date field, a Quarter field with values 1-4 to represent quarters, and finally a quarterly_value column. Here's where it gets fun. Not all months and quarters are present in the dataset. There will never be a monthYear with more than one row (i.e. never two rows of DEC 2023).…
First time poster!! Thanks for all the help you've contributed thus far Domo Community. I'm trying to create a year over year comparison graph with our locations on the X Axis, instead of the required time period on the x axis. The period over period comparisons are only available when Time is used on the x axis, so I…
Trying to create a sql statement in magic ETL to compare YOY: Month-to-Date (MTD) by MAX date. My current code from is: CASE WHEN (MONTH(MEMBERSHIP_INSTANCE_PURCHASE_DATE) = MONTH(CURDATE()) and YEAR(MEMBERSHIP_INSTANCE_PURCHASE_DATE) = YEAR(CURDATE()) and DAYOFMONTH(MEMBERSHIP_INSTANCE_PURCHASE_DATE)…
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