Ask Magic ETL questions and get answers from Domo peers
Hi, I am struggle to get a beast mode formula to work for calculating the sum of same week last year, our business date start from Sun- Sat, i want to get the formula to only calculate previous week data e.g. today is 24th Wed but i want to calculate the week from 14th Sun -20th Sat DOMO says the formula for LY is…
I am looking for a way to show a bar graph with sales data by period and a growth rate line with period over period percent change. I have a detailed dataset with a large amount of sales data spanning over multiple years. I am having trouble with how to get the prior period data to be on the same line and to be dynamic so…
I am not sure of the best way, but is there a way for me to take the raw data below and make a table and/or chart?
I want to create a dimensional variable that allows users to choose between WoW, MoM, QoQ, and YoY using the chart types below. What is the best way to go about this? Any tips on creating the ETL to create the components above?
Hi, I'm having an issue. I want to split the fruit column by comma then alphabetize, then bring them back together on their respective account ID. How would I do that in magicETL?
I have data showing the start and end date, such as the below. I want to use a chart to show starts & ends side by side by week. Is this doable with a ETL or beast mode? CandidateName CompanyName StartDate ActualEndDate Name1 Company1 12/23/2024 Name2 Company2 12/23/2024 Name3 Company3 12/23/2024 Name4 Company4 12/23/2024…
Community, My data is formatted per my example screenshot below. Is it best to pivot each location into rows, or is there a benefit to maintaining columns for rows? I will need a total number, and then drill down numbers (I.e. Total Net Profit = 30 > Drill Down > Omaha Net Profit = 10)
How would I remove the loans that have a PaymentInFullDate associated with them? Can this be done with magic ETL?
I am currently struggling to find a cohesive solution to being able to fill nulls with the first instance of a non-null value. The layout is very simple, basically there is column called ID and it contains one non-value null and the rest is null until the next non-value null. I would like it where the nulls are replaced by…
Hello, I am currently testing out Upsert for the Update Method of the output dataset and I am confused about how it functions. From what I understand, it serves as both an append and replace update method where you can append on the current data to the historical data that exists. The issue I am facing is that I wanted to…
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