Ask Magic ETL questions and get answers from Domo peers
Hi all! I'm back with more beginner level questions probably :) I feel like I've done the complex piece for this which is writing 24 different Beast Modes. I'm just struggling with which Actions to use in the ETL to bring all these Beast Modes together at once. This looks like a fairly useless mockup because there's no…
Is it possible to add fixed functions in the magic etl? This is the fixed function I'm referring to. SUM(SUM(Term length (lookup)) FIXED (BY Document Number)) I can add it in as a beast mode, but can't add it as a formula in magic etl.
Hi all, First time posting here, and I'm just looking for some guidance on if this is even possible. Any help is greatly appreciated! We have created a report in Domo that is using 3 separate cards, all from the same dataset. Each card has a different "Total" because in Analyzer, there are various factors filtered out. In…
First off, I'm a Domo newbie, only been working with the program for a couple of months now. I discovered an issue with an ETL I've been working on that uses a colleague's data set as an initial input. The source table itself is updating just fine, showing recent data. But when I look at the input data source, I only show…
Hi Community, I am struggling with combining two data set like below As you can see we have one campaign but has many views. When I combine these two, spend would get allocated to all the rows in table 1. How can I join these two table without overcounting the data on table 2?
Hi - I'm trying to figure out the SQL code to sum (A) bill rate + (B) bill adjustment = Total Bill. However, Bill Rate can either be (A1) Original Bill Rate or (A2) Posted Bill Rate. Similarly, Bill Adjustment can either be (B1) Original Bill Adj or (B2) Posted Bill Adj. Logic is that If the (A2)Posted Bill Rate is NULL,…
I have a dataset that represents order information. Each row is a unique order ID. One of the column values shows the quantity. I would like to duplicate (or replicate) the rows based on the value in the quantity field. Example OrderID 12345 has a Quantity value of 5, so in the output dataset, I want 5 replicated rows for…
Is there a way in Domo to understand the actual size of the dataset? I know we can find the row count, but I am not sure how to find the size in GB/TB.
I need to find a way to pull in many rows of data. I have two months worth of data which is essentially 110M rows. I need to pull in at least a year. Is there a way to do this? I tried the ETL partitioning method but it said 'too many rows of data'. Would workbench work with partitioning here or would I get the same error?…
Question is self explanatory, in MySQL you can use the SELECT version () command to determine this, but you can't in the tiles. What is the version?
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