Ask Magic ETL questions and get answers from Domo peers
I used the Lag function to operate a subtraction between data point and previous data point. However now I need now the average for that new column (which I am not able to do in Beast Mode) Any suggestions
I'm trying to create a card that can be used to present to budget owners how much they have currently spent for the month compared to the budget they've been given. In order to do so, I have to create a dataflow that involves joining 2 datasets; One is Netsuite, which stores all the journal entry transactions, and the…
I currently am bringing in data from google ads and one of the columns is `landing page url`. I am trying to parse this row from: https://m.ufhealth.org/uf-health-pregnancy-care?utm_source=google&utm_medium=tj%20ppc&utm_campaign=fy21%20ob%20services&gclid=EAIaIQobChMIo7Hl4pCq8gIV_21vBB1iYQ_JEAAYASAAEgJD3fD_BwE to uf health…
Our business model currently offers multiple product options. I'd like to create brand new rows for each customer, 1 for each product, whether they own that product or not. My thought is to use new columns and then use a dynamic unpivot. Need help creating the new columns first though.. Currently have this: Account Product…
Hello, I have two data sets that i would like to join based on a between condition. The "Join data" available in the ETL shows only inner & outer joins. Where can i do custom joins? Here is the detailed scenario. dataset A has 2 columns - clicks, date dataset B has ID, start date, end date. I need an output with B.ID,…
I am working on converting some Redshift dataflows to Magic ETL 2.0 dataflows. I have a join statement in Redshift that looks like this: SELECT d."province_state" , c."Category" as SeverityRelativityCategory , n."Category" as SeverityRelativityCategoryMinusNY FROM "ihme_covid_19_population_death_shares" d JOIN…
Hi Everyone. I'm looking for strategies to reduce the run time of Magic ETL 2 data flows. I'm working with several left joins in sequence on about 17 datasets of 1 million rows each. Beyond this, the ETL performs no other operations. I'm curious if anyone has experience with these options: Data fusion Adrenaline Redshift…
Hello Domo Ninjas - I'm trying to get a new value from a dataset, where I'm dividing 1 column by another. Its a strange way of measuring how much Sales is adding on Services to Product deals. I'm getting errors both in Beast Mode, when I try MOD(ProdSales,SvcsSales ) And in DataFlows when I add a Calculator, attach it to…
Tring to split the values in a column into multiple rows using explode and I keep getting an error. I am not too familiar with the python tiles... The value in my row will be "A<br>B" and I want them to appear as two separate rows, one with A and one with B. Getting error: "00:00:01.817 domomagic: Version 0.3 00:00:01.819…
CASE WHEN `end_date__c` >= '1/01/2021' and `end_date__c` <= '12/31/2021' then `2021` else 0 end getting an error message Calculation Error : A column in this calculation did not exist.
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