Ask Magic ETL questions and get answers from Domo peers
Hello. I have 3 cards in my dashboard. Can anyone help me create an ETL for the 3rd column only, please? Here are the details and filters for each card: Card 1: Company Name not in 'MR' Destination contains 'MR', 'TC', 'L', 'NP', 'PP' show count of ID ——————Card 2: Company Name in `MR' show count of ID ——————Card 3 (here's…
Currently am using this formula to exclude current week: CASE WHEN WEEK(Snapshot Date) >= WEEK(maxSnapshotDate) AND YEAR(Snapshot Date) >= YEAR(maxSnapshotDate) THEN 0 ELSE 1 END however, it is excluding Sundays data. (I want to look at Fiscal calendar and it is selected under date settings)
I am trying to change a field that shows up as a text field to a number, but I am getting the below error in magic ETL. Any ideas on how to change this field to a number?
I'm not sure if something changed with Domo recently (upgrades or modifications), but I have a magic ETL and all of a sudden one of my tiles is hidden beyond the range I'm able to scroll to on the right side. So I cannot open this tile or grab it to move it. Very weird. Our ETLs get massive and often end up filling the…
Hi all, I have a problem where if the 'used' column goes above the 'authorized' column then we need to start adding to the 'used' column below. For example, when we use over 700m of our authority (total authority is 1.55 billion) then we need to start adding to the 2nd line of 'used' i.e. if we have used 790 million then…
Hi, The date in my data set is formatted as YYYY-DD-MM. As shown below: By default domo assumes the date is YYYY-MM-DD. Therefore all my data is grouped as Jan 2016. Is there a beast mode calculation to reformat the date? Thanks, Angel
Hey there, I have a Webhook data coming from Wix that looks like the following "VIC Player Hosting Fee (April Cloth Camp) AUD 87.00". I need to seperate the monetary value at the end of the string and convert from text to integer, but have tried using methods like CAST and the Alter Columns MagicETL tile to no avail. Any…
I have a Dashboard named "Dashboard 1" which has a sub-dashboard named "Dashboard 2". It is possible to "drag" the sub dashboard out of it's parent Dashboard so it is stand alone? I would like to delete Dashboard 1 and keep Dashboard 2. Any help appreciated! Thanks
Hello, I am trying to join two datasets one is a huge datasets that has all employee numbers in the company and the other one is another dataset that has a list of different case numbers and a requester employee number that I am trying to validate the employee number and the their tiers using the bigger employee dataset by…
Hey all, looking for ideas. I have a data set that has shipping lanes (Origin/Destination) and then a summed cost and revenue for each shipment on each lane. Then a margin based on that for each lane and shipment. I have each lane summarized into a monthly average, but I would like to be able to break that down a little…
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