Ask Magic ETL questions and get answers from Domo peers
I have a dataset in which i have two columns of date timestamp values in format YYYY-MM-DD HH:MM:SS 1- Date created 2- Date Closed I have subtracted this with a beast mode to get the days and hours minutes: Beast mode name : Test01 CONCAT( DATEDIFF(Date Closed,Date Created),' ','days',' ',TIMEDIFF(Date Closed,Date Created)…
Hello, I am trying to use the rank & window function to grab the latest date in a column, but am confused as to how to set up the tile. Currently this is my set up: I just want to grab the latest date, but it says that the tile/action is not being configured proprely. Any advice? Many thanks in advance!
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?
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