Ask Magic ETL questions and get answers from Domo peers
Every quarter I am adding a new budget file, and when I am adding Q3, I get this error. This did not happen for Q1 and Q2. The file I am adding does not have a BATCH ID column, but I do have an email connector set up to receive a weekly file for the actual data, that does have a BATCH ID. I know this one might be hard to…
Why does the order of elements change every time we run an API or an ETL? If I put a select column tile on an ETL, immediately followed by an output, I would expect the output fields to be in the order of the select column tile. I'm currently working on a complex aging flow and running the flow makes the dataset wonky and…
Hello, Please see below on what I am trying to do. I have open orders that are ranked based on earliest ship date and the ORDQTY. I am looking at the total sales QTY for that model and trying to do a lag calculation to see if a specific line item is fulfilling the outstanding sales qty or going into a negative number which…
I'm trying to connect two datasets to track contract fills per week. The screenshot is from one of the two datasets and it includes the contracted amounts of each commodity and the Start/End dates of the contract. The second dataset has data pertaining to the amount of cases actually received per day (which I have…
Hi Community - thanks as always for the consistent great help. I'm attempting to Group/Pivot/Join/Append (not sure exactly what the methodology will be) multiple rows of Patients into single rows with additional columns. Right now, each patient event is on it's own row. So, a patient seen on Monday and then also on Tuesday…
Hello. I have 3 cards in my dashboard. Can anyone help me create an ETL for the 3rd column only, please? Here are the details and filters for each card: Card 1: Company Name not in 'MR' Destination contains 'MR', 'TC', 'L', 'NP', 'PP' show count of ID ——————Card 2: Company Name in `MR' show count of ID ——————Card 3 (here's…
Currently am using this formula to exclude current week: CASE WHEN WEEK(Snapshot Date) >= WEEK(maxSnapshotDate) AND YEAR(Snapshot Date) >= YEAR(maxSnapshotDate) THEN 0 ELSE 1 END however, it is excluding Sundays data. (I want to look at Fiscal calendar and it is selected under date settings)
I am trying to change a field that shows up as a text field to a number, but I am getting the below error in magic ETL. Any ideas on how to change this field to a number?
I'm not sure if something changed with Domo recently (upgrades or modifications), but I have a magic ETL and all of a sudden one of my tiles is hidden beyond the range I'm able to scroll to on the right side. So I cannot open this tile or grab it to move it. Very weird. Our ETLs get massive and often end up filling the…
Hi all, I have a problem where if the 'used' column goes above the 'authorized' column then we need to start adding to the 'used' column below. For example, when we use over 700m of our authority (total authority is 1.55 billion) then we need to start adding to the 2nd line of 'used' i.e. if we have used 790 million then…
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 DomoAI and get answers 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