Ask Magic ETL questions and get answers from Domo peers
I have a card that i'm intending to use to track fill % of contracts. The card has columns for Commodity, Week#, Contract Weight, Actual Received Weight and then a Beast Mode Column to calculate the % of the contract filled. I'm feeding the card through an ETL. There are two input datasets in the ETL. One consists of…
I have two datasets. One is structured as the "primary" expense file, where each row is dates and other dimensions for each credit/debit. The next is credit card transaction details. They share transaction IDs in a column named Doc, share GL #'s, and share posted dates. The combination of all 3 of these things will result…
I am trying to sum up 2 columns that meet certain criteria and would like to create a new column with the values. Here's what I have so far: SUM( CASE WHEN Goal Funnel Category = 'Interest' THEN Total Actions WHEN Page Funnel Category = 'Interest' THEN Total Actions ELSE 0 END ) I am getting the error below but wasn't sure…
Hoping someone can help me with this. I want to ingest csv files from our S3 bucket where the first column is the date column. That column also has text in it: I am also getting this error "Failed to parse text '2/1/23' from column 'Date' as type 'Date'" from one of my files. I've tried fixing the file itself but it's not…
Hello, I have a question in relation to cards: how can the "warning not all data is shown" be removed from a card, such as below? Thanks!
Hello again! I have a question about the "no data filtered in range" in cards. How can I turn this to display 0? Thank you!
Hello, I am having the following trouble when changing the data type inside an ETL: basically I cannot change this string format to a date format: Any help would be greatly appreciated!
I am bringing in survey data and the question has both a string and an image in it. I am trying to separate these in an ETL but split part, regex replace, and split column are not working. The string looks like this "<br />Test<br /><img height="150" width="20……" I am trying to split on <br /> but its not doing anything. I…
Hello everyone, I am trying to remove the 0 to format my dates as in the following screenshot: Any advice? Thanks!
I have a dataset in which i have two columns of date timestamp values in format YYYY-MM-DD HH:MM:SS 1- Date created 2- Date Closed I have subtracted this with a beast mode to get the days and hours minutes: Beast mode name : Test01 CONCAT( DATEDIFF(Date Closed,Date Created),' ','days',' ',TIMEDIFF(Date Closed,Date Created)…
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