Ask Magic ETL questions and get answers from Domo peers
Hi all, I am working on creating a DataFlow as I needed to format a column from text to a date. During this process, it changed 'Net Change USD' from a Fixed Decimal to an Integer if I don't alter the column. I have altered the column to show 'Net Change USD' as a fixed decimal but it changed to just a decimal with the…
I have snapshot data everyday that has customers and their statuses. I want to create a formula that looks back one day and reports the status (previous day status) How would I do that in Magic ETL?
Hi, I am trying to build a multiline chart based on the following Dimension: Date (x-axis), Search query (line series) Metrics: impressions and position The multiline chart should show the position (y-axis) by date for only the top 10 search queries based on the total impressions during a the selected time period. I cannot…
Hi all I have 30-40,000 rows of data presented to a bar chart with 5 dashboard filters operating across the data. There are 15 different categories presented as the x-axis. Occassionaly filtering removes one of these categories. I'm trying to find a way to leave the category on the x-axis despite the fact that it is no…
I'm trying to use windows function in the new SQL tile. For example, I have a dataset with three fields: Gender, rank, students; I want to aggregate by gender, sort by rank and sum students cumulatively so the last row of each gender category contains the total number of students. I tried the following query and got an…
I have rows of data that look like this: Customer: ID: 12 NULL 12 NULL 12 NULL 12 NULL 12 NULL 12 56 How do I fill in the above rows with the customer ID, 56, Using ETL?
Hi all! I'm back with more beginner level questions probably :) I feel like I've done the complex piece for this which is writing 24 different Beast Modes. I'm just struggling with which Actions to use in the ETL to bring all these Beast Modes together at once. This looks like a fairly useless mockup because there's no…
Is it possible to add fixed functions in the magic etl? This is the fixed function I'm referring to. SUM(SUM(Term length (lookup)) FIXED (BY Document Number)) I can add it in as a beast mode, but can't add it as a formula in magic etl.
Hi all, First time posting here, and I'm just looking for some guidance on if this is even possible. Any help is greatly appreciated! We have created a report in Domo that is using 3 separate cards, all from the same dataset. Each card has a different "Total" because in Analyzer, there are various factors filtered out. In…
First off, I'm a Domo newbie, only been working with the program for a couple of months now. I discovered an issue with an ETL I've been working on that uses a colleague's data set as an initial input. The source table itself is updating just fine, showing recent data. But when I look at the input data source, I only show…
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