Ask Magic ETL questions and get answers from Domo peers
Hello DOMO - Good Day! I am using the Data governance dataset that has the users and groups. what we wanted to show is the pages/dashboard and then all the groups that can view it. currently, I can show the different pages and the different groups in different columns. just wanted to know if we can show all the different…
Hello, I am trying to accomplish a New DataSet using the Magic ETL where I combine multiple rows that have the same data in one column, but then create new columns for the data that isnt the same in other columns. To better explain, I have provided an example here. (Please see screenshot below) I have tried using "Group…
Hi all, using the following to calculate time differences between requested and actual drop off times: TIME_TO_SEC(TIMEDIFF(Actual Drop-off Time,Requested Drop-off Time)) / 60 Seems like the math isn't panning out (first column should be ~25 in the time difference column but instead is showing 1415.80). Haven't used the…
Hi, Can I use SubDate to filter a dataset within Magic ETL? We import our leadership team monthly. However, there are certain reports where I need the end of quarter leadership team instead of the most recent leadership team. Right now, I have the quarter end date hardcoded, but I would like to have a dynamic function.…
Hi everyone! We have set up an email connector and added the rules as below: HEADER ROW - 16 STARTING DATA ROW - 17 Update method - replace This is because the rows above 16 contain report summary data which are not required in the dataset. However, whenever the automated report comes through from the connector, we are…
I want a card with a single line of text. Not a table. This is to act like a caption textbox. To indicate last run. The text is to indicate most recent date within the dataset. Assume there's a column called [date]. Here's the tricky part. This date must be based on the data itself. We have many offices. When filtered to…
Hi all, I have a 1.5 million row table that has been used many times over. For some reason, when I went to use it this morning, it was not wanting to work. I have a 'Bankruptcy Date' column that I feel pretty confident only has dates in it. I get this error code when I try to run this dataset through a dataflow. I cannot…
How do I sum a measure (activities) specifically for last week (Monday - Sunday) within ETL? I also would want to do for the week before. For context, my ultimate goal is to take an existing formula in ETL showing total potential activities for the week (which is constant) and then subtract the actual activities for the…
Hi, I have a question concerning how to fix an issue I am having when attempting to sum daily averages. Here is the issue that I have. As you can see in the image below. I have dates, IDs, and a daily average amount, set up in a dataset in my etl. In this sample, there are a total of 2 distinct IDs, the way I would like…
I have various start and end dates for campaigns. I know how to calculate the # of days between any get set of dates. But, what I am trying to set up in the etl is this - if I have a budget amount, start date and end date, what is the easiest way for me to have the etl calculate the division of the budget over the given…
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