Ask Magic ETL questions and get answers from Domo peers
Hi, I have a column name 'Order' with 1 to 6 values in it. I need to calculate the percentage of order 1 and show this percentage on a card in the dashboard. This percentage should change dynamically when the data gets refreshed. I am taking unique count of orders having 1 divide by total count of orders. when i am…
Reposted here: Can't get Group & Join to Work — Domo Community Forum
Hello DOMO - Good Morning! Recently we have new people in our group that we have appended (Trainer) in their names. and we want to update their DOMO names as well. but in DOMO, after sometime, there are names that revert and goes back to just their names without (Trainer) appended. and there are some that don't. We just…
Any idea how to fix this error? It seems that my columns are a floating point, so not sure what the fix needs to be.
I'd like to calculate the cumulative number from daily count and copy the cumulative number from previous day or 2day before or 3day before if no data. If there are no function on Magic ETL, it is OK to create SQL.
Hi all, I have this ETL which takes a multi selection attribute (Div) with 19 values and does the following: Splits each selection option into its own column Converts the columns to rows Filters to remove instances where there was no delimiter, because if only 1 of the 19 values was selected - these showed up as "Not…
My dataset has a Month column. I want to pivot the data so that the months become the columns (so a column for June 2024, a column for July 2024, etc). Using the Magic ETL pivot tile it seems I'd have to perform the pivot for each month separately. Before I go down that route, does anyone know an easier way to do this?…
I have a column in a dataset of production data. The column is formatted as follows: Production Cherry Tomato 12x1pt - Packed Beefsteak 15 LB - Restack Mini Sweet Peppers 14x4 FM - Packed I'm wondering if there is a way to pull the "12x1pt" "15 LB" and "14x4 FM" into a column for "Size". Given the varying amount of white…
Hi, I am new to the tools within the governance toolkit. I have been doing some research but wondering if anyone has any use cases for, or explanations of the following tools: Dataset Backup: Is this just a safety measure to take before you modify an existing dataset? If so, what would be the difference between this and…
I have a scenario where I have rows from multiple columns that I want to pivot into a multiple columns. Let's say I have three columns: 'Questions,' 'Labels,' and 'Values.' I tried pivoting the 'Questions' column into separate columns with values from the 'Values' column. Now, I also want to pivot the 'Labels' column into…
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