Ask Magic ETL questions and get answers from Domo peers
I've got two data sets I am trying to combine in Magic ETL to calculate inventory turns. In the sales data I have 2 1/2 years of history that updates weekly. In the ETL in preparing the sales data I need to filter to just the last 12 months (from last date in the set). Since this last date updates each week I'd like to…
Does anyone know how to calculate an age from a person's date of birth and a date of interaction using beast mode? In other words, if a client utilizes a service on 07/08/2019 and their DOB is 09/09/1999, the formula would find the client's age based on the day of the interaction rather than the current date. In Excel, I…
Afternoon all, Having a hard time figuring out this one out. I have a tabular report i'm connecting to in salesforce, which is a "Campaigns with Influenced Opportunities" report. The report shows a line item for all campaigns that contain a member with an opportunity. The member can be associated to 1 opportunity, but be a…
I am using a magic ETL. I have tried using a left join but it returns the rows that are not in the other column and also all the left column rows.
Hello All, I need to build a beast mode for a table chart that will show only the top 25 accounts. I tried to export only 25 rows, however it doesn't export in the order I have them lined up as. I cannot add anything to the ETL as this will change all the data. I just need to add it to a card. The top 25 is based on…
Hello, I have a dataset with a list of all customers and their recurring/non-recurring recognized revenue by quarter. Our business has a tremendous amount of seasonlity so I'm trying to report a rolling 4q total. How could I go about showing the sum of a quarter and the 3 trailing as well?
Hi, I am trying to combine the distinct value from multiple rows in a column with Beast mode. Here is an example of my file: Field AField BFieldCA1111A2222A3333A4333B5111B6444C7555 I would like to have: Field AField BA111, 222, 333B111, 444C555 In this case I have a concat but I would also need to do a distinct sum…
Is there an easy way using Magic ETL to create new columns based on existing columns. For example I have an ID column and a Page Name column and want to make each ID and Page Name a net new column to link to other data in the dataset. (I'm using governance Page data) Any ideas here?
I have a column where there are around 34 values that are duplicated for one line that is supposed to be for two people. See picture for example. Ideally it'd be great to have one formula that can distinguish where the break would be so I don't have to manually create 34 lines of code, and have to continually add lines…
Hello! I am trying to replicate an excel formula to determine the number of times a caller calls within 4 days, 3 days, 2 days, and 1 day. I would like to create a field for each of these time windows. If someone calls 6 times within 4 days, I would like the 6th call to have the number 5 in it in the "4 day window" flag.…
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