Ask Magic ETL questions and get answers from Domo peers
Hello, I'm looking for help with a problem I'm having comparing pay for a pay period to a providers billings. I have removed rows for simplicity in the screenshot below, but I'd like to sum the `Billed Amount` between the `Period Beginning Date` and `Period End Date`. Then I'd like to show that info on a bar graph with the…
Hello Domo users, I need to count the number of occurrences grouped by a given field. See the example. I tried a beast formula, but I cannot get the total number of occurrences. Is there a way to do it using a beast mode? Or is there another way to figure out the number of occurrences? Maybe using Magic ETL? I would prefer…
I have several datasets that have over a hundred columns... and I'd like to have them sorted in alphabetical order. Is there an easy way to do this without having to go through and manually adjust their order using Select Columns in an ETL?
What is the difference between Multi cloud and federated? We use snowflake for data warehousing, trying to figure out what's the best way forward. and is there documentation that spells out these differences.
Hi community, I'm not sure if this is by design or if this is a bug. Filtering data within a field will completely filter out the blank values as well. It looks like Domo won't recognize the Blanks as a value. This is an scenario: FieldA, FieldB CategoryA,12345 CategoryB,58679 ,89658 CategoryD,97865 CategoryY,74935 Filter:…
hi all, In the organization I am currently working in, we reached a point where we are developing and maintaining a lot of dashboards. Whenever we update datasets or update/modify dashboards, the users were also able to see those changes. This is becoming an issue as users think there is a problem with the dashboard, but…
I have an ETL with several joins and calculations. My final output is good except for this last piece: I would like to identify in a formula that when the "ID" column has the same # but the "Status" column is different, then I want to keep the status result from the "last update date" column. Is there a formula I can use…
Why does Domo not have a simple way to delete certain rows that match a criteria? How can I delete certain rows from a dataset? Analogous to SQL "DELETE FROM"
I am not an SQL person by any means. I am using a Data set where I am comparing the supervisor's name to the employee's name (All names are on this data set) and copying the Supervisor's Email into the Employee supervisor's email column that is blank. So in theory Steve's email will be copied into Jim and Luke's line.
I think I made a a mistake of having 1 ETL facilitate some simple transformations for several input datasets. I have the ETL triggered to run whenever any of them update... but now it occurred to me that the ETL is going to keep running every time one of them updates - and I'm afraid it won't pull in the latest updates…
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