Ask Magic ETL questions and get answers from Domo peers
Hi All, I am trying to create a Magic ETL V2.0 that lists the name of the months in between a hire and termination date for employees. I want to create a bar chart of number of employees who are active and terminated within a given months time. i.e. Hired: 5/1/2022 and Terminated: 8/31/2022. Months active = May 2022, June…
Hi All. My dataset have a lot of duplicate rows so I wanted to use "Remove Duplicates" in ETL based on the Shipment ID. However, there are some products that are hazardous. I want to have the hazardous row left remaining when I remove the duplicates if there is a mix of Haz and non-Haz. Any function or use of "Rank &…
For some reason I am getting a self referencing value rather than a NULL. In this example, I was expecting the Next Row Column to be NULL for the last row. Instead, it seems to be self referencing the student enrollment # column. The first 5 rows in the example are correct. Is this the default behavior of this…
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…
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