Ask Magic ETL questions and get answers from Domo peers
I'm trying to built a basic table card that only shows records where the Brand attribute is NULL. I know for a fact that there are records that meet this criteria in my data set, as shown in the image below. What's puzzling is that when I apply the filter, it doesn't return any records. The filter works as it should for…
I am trying to set up an ETL or logic where any time a new incidence happens, the clock resets. Problem statement would be - How many days can a company go without recording any incidences being recorded. Once the incidence happens, the days resets.
Hello, I started working on an ETL and then later made changes to a copy of it. I want to delete the original in order to keep the Domo instance clean (the completed task is in the copy). Will deleting the original cause any harm? Thanks in advance!
Hey, how would I create a last updated card on top of a dash? This way it gives the users the understanding of how up to date the cards below are, etc. How would i create that on the dataset to then even be able to apply to a card? Thanks!
Hello good people of Domo Very frustrated trying to remove duplicates WITHIN a comma seperated list. I have the following webform: If I 'Group By' (Magic ETL) by 'Who' & 'Manufacturer' (combining 'Model' & 'Colour' with commas) I get the below. This has repeats in R5:C3 (2x 'TT'), R6:C3 (2x V70) and 'Black' is repeated in…
Hello all! I noticed a post or two discussing that there was a Business Days or Workdays-type function in beta and I am wondering if there are any solutions to finding the number of business days between two dates until this solution goes live? My data is fairly straight forward; assuming two columns [Date 1] and [Date 2]…
Good Morning and happy new year, Is there a way to see what dashboard a dataset is used on? thank you!
How can I use MagicETL to update the rows with NULL Source values to have their relevant Source value, based on ID? Starting Table ———————- Source | ID | RankCol ———————- plant | 100 | 1 NULL | 100 | 2 animal | 101 | 1 NULL | 101 | 2 Desired Resulting Table ———————- Source | ID ———————- plant | 100 | 1 plant | 100 | 2…
I'm trying to calculate the average fee per event earned for the previous year and add that as a constant to a dataset to use to calculate projected fees for the upcoming quarter. I can calculate the constant by using Group By to get the average fee by year and then adding a filter formula to isolate the prior year but how…
I have a number of ETLs that may need to be extensively updated or removed. I would like to create a backup. I understand that there is a versioning capability built into Domo, but it would be very useful to have an offline backup as well. Besides manual work, is there a way to do this?
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