Ask Magic ETL questions and get answers from Domo peers
Hi, so I have a beast mode calculation in one of my datasets that looks like this: CASE WHEN SUM(SUM(1)) OVER (PARTITION BY TRACK: Title,LIBRARY: Name,TRACK: Version) > 1 and TRACK: Version = 'Full Mix' THEN 'YES' WHEN TRACK: Version <> 'Full Mix' THEN null else 'NO' end The purpose is to make sure that there aren't…
Hello Team, I am trying to do a ETL in domo but unable to get desired result please suggest. In my input, i have a few columns, the lowest grain in Employee id, I have a column called Value, In this values are given using delimiter "|". In my below example there are 2 instances on "|" but in my data it can come any no. of…
I have implemented some conditional formatting using this code in an HTML table: $(myTable).DataTable({ data: reorderedData, lengthMenu: itemsPerPageOptions, columns: colNames, createdRow: function(row, data, dataIndex) { var daysOld = data[0]; // Correctly reference the first column if (daysOld == 1) {…
I have a simple card with a Table on it where one column that has a HTML link created with a concat function. The link is to call an Azure API and I'm trying to modify the link so that it will call the API silently instead of opening a new tab each time. I was able to play with an HTML brick and get a Javascript onclick…
I have data with Plants and Assets. I need to transform so i have data in each row and not multiple assets separated by commas in each row. How do I do this in Domo? Current Structure Plant Asset Shutdown Reason Plant A 1, 2, 3, 4 Maintenance Plant B 3,4,5 Other Structure Need Plant Asset Shutdown Reason Plant A 1…
I have an ETL that is scheduled to update once per day, but every time it runs automatically, I get a failure after about 10 seconds stating: "Failed while executing. Illegal number of inputs. Expected one but got zero." I usually can rerun it around 2-3 times manually and then it works. There are no errors that I can see…
hi All, Good Morning We can see some different lists of date - functions throughout DOMO. Under Beast Mode, you can see more Date Functions Under ETL( dataflow) page we can see a limited Date Function. Example DAYNAME() function. The dayname function can be seen under the the BeastMode page but the Dataflow page is…
I have an ETL that produces an output where one of the columns is calculated using a formula. The output is generated using the "append" method and the input moved from being all time data to only L4D worth of data. The problem I have is that, due to some business circumstances, I have to re-calculate that column but I…
My current dataset has these columns: Jan 2024 | Feb 2024 | Mar 2024 | Apr 2024 ………. and so on. And I'd want my table to just have 2 columns: Date and Point So I used Unpivot tile, but I am unsure how to label my the new Date columns (number 4), so it will turn into a date format using Alter Column tile afterward. Do I…
I have a column that show 2023 sales as "$3,432.12" kind of format which DOMO identified as Text. However, I think I need to get rid of the "$" at the front before using Alter Column Tile to change it into Floating Decimal. How can I do that?
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