Ask Magic ETL questions and get answers from Domo peers
Howdy! New Domo customer here - first time posting in the Dojo! We're bringing in accounts from various systems. Sometimes an account from system A is the same account in system B. I'm wondering if there's a way to do some sort of smart match to automatically establish relationships between records. Something like, if the…
I have two questions: 1. Is there a way to sort the legend in a specific order and have it stay that way? I would like it to be as follows: A B C D F But I am having trouble finding the option in chart properties. 2. There is also an extra option in the key that is showing up that doesn't apply to anything. Is there a way…
I Need to create this nested statement in the Domo Dataflow but I keep getting a syntax error. I tried doing it a few ways and both are creating errors SELECT CASE WHEN "Status__c" in ('Booked') AND > 111 THEN 'TIER 4' ELSE 'TIER 1' END FROM "sfdc_travel_raw" or this query SELECT *, SUM(case WHEN "Status__c" = 'Booked' >…
I've got a requirement to change the appearance of articles and prepositions in words in a column to be displayed as lowercase after running a Title Case on the rest of the phrase. Right now, I have an extensive list of text replacements in Magic ETL to do this, but I was wondering if there might be a way to do this with a…
Is there a way to be able to edit the column description field massively. For example if I have all the descriptions that need to be input but there are datasets that have over 800 columns .... is there a way I can upload these to the dataset?
I have a start date, I want to know the next work day after a specified number of days. (exclusive of weekend and public holidays). In Excel, WORKDAY function can do this. Would like to know how to achieve this in DOMO. Thanks for any input.
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.
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