Ask Magic ETL questions and get answers from Domo peers
I am trying to convert a string column to floating decimal, but I get the below error. How can I fix?
My dataset has a Year & Month columns, I would like to add a 'Month End Date' Date column into this dataset with magic ETL. But each month has different end date so I'm not sure how to go on about this
I have a data set that brings in names under the column BDM Name with FY 2024 at the end of the name, see below screenshot. What is the best way to remove the "FY2024?" I have about 8 BDM names I need to change. Should I use a replace text tile in ETL?
Hi, I am running into a weird issue. In most cases you can use "Save As" to make adjusted copies of a card or dashboard without changing the original. However, that's not working for ETLs for me. Instead of having a separate ETL, it keeps sending me back into the original. I'm just trying to apply the same name mapping as…
Dataset A columns: Name, Bday, Age, Gender, City Address, Country Dataset B columns: Name, Position, Salary, Company columns I only want and will name as DatasetC: Name, Bday, Age, Position, Salary I am thinking if I can just use Dataset B, save as Dataset C and add columns (Name, Bday, Age) from Dataset A. But I don't…
Hi, I am trying to build a card that shows the broken beast mode by owner name, but can't find the owner name. I tried to link the 'DOMO Governance - Beast Modes' data set with the 'activity user' dataset which gives me the owners of the card, page, and even dataset, but how do I find the owner of the dataset? Any help…
I have a field from NetSuite called duration, which is a measure of time in this format 8:30 This stands for 8 hours and 30 minutes of work time. I need to convert it from a text to a number so I can create measure. Thank you! Jayme K.
SEC_TO_TIME(SUM((End Time - Start Time)) - 3600) I am using the above calculation to get the employees who has exceeded their break by 1 hour. it is working fine in normal condition but when i put this into pivot and checking the subtotal / total, it is just subtracting 1 hour from the total which is wrong. it should just…
Our database looks like this: We have separate columns for TransactionType, new_policy and renewal_policy. So when we build the card, the New policy and Renewal Policy won't come under the Transaction type, which we want to visualize like this: Question, How can I add/merge "new_policy_count" and "renewal_policy_count"…
Hi, I have a process_timestamp column with string values like this: 2024-09-17T14:47:41. I am trying to convert it from a string to a timestamp in the format 2024-09-17 14:47:41. I used the formulas below in my ETL, but they are not working, and I get this error message "failed to convert value from type string to type…
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