Ask Magic ETL questions and get answers from Domo peers
Greetings, I have aggregated transaction data using the Group By tile to produce the following schema: Project ID (GROUP) Amount (SUM) Labor Cost (SUM) I then join this dataset to a list of transactions which are also grouped by Project ID. Left table = = Transaction dataset Right table = = Grouped dataset from above…
I think the answer to the title is you can't, but to get to the point, I'm trying to go from this input to this output: A Group by on Requestor Organization, and another on Phase works as intended on the Preview, and I am then doing a Pivot on the Requestor Organization to turn it into columns, but I'm still not sure how…
I have a singular dataset that includes Live dynamic data, and historical fixed data. For each ProjectId, I need to SUM the PlannedCost of the historical data with a specific timestamp, and SUM the PlannedCost of Live data, so that I can compare the two in Analyzer. Below is an example of the Input dataset for a single…
When joining datasets, Domo alerts you to any conflicts in the naming. Specifically, any common field names have to be renamed. It defaults to using the name of the originating dataset as a prefix. We use longish, descriptive dataset names, and the narrow, static width of the editing line makes renaming very tedious. Is…
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…
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