Ask Magic ETL questions and get answers from Domo peers
I need to find a way to pull in many rows of data. I have two months worth of data which is essentially 110M rows. I need to pull in at least a year. Is there a way to do this? I tried the ETL partitioning method but it said 'too many rows of data'. Would workbench work with partitioning here or would I get the same error?…
Question is self explanatory, in MySQL you can use the SELECT version () command to determine this, but you can't in the tiles. What is the version?
As always, terrible title by me I'm sure :) This is quite similar to a question I had last week that @rco helped me with, and I'm using his answer as the basis for what I'm working on, but am stuck on getting it to work. Last week I was doing counts of projects, but this week, I need to SUM the project cost. Simplified…
Hello, My backend data in excel has over 50,000 rows and one of the column is #ID shown in the below screenshot. I am searching for an existing ID "9996", but it just shows the 3 values. And I see the note below the search bar which is confusing, and not sure how to filter the page to see all matching unique values. Please…
Hi All, We are working on a report that has a few different program_namesthat are summed up in a pie chart using orig_loan_amount. I have been tasked with trying to sub categorize our bonds using a taxable/tax-exempt designation The problem I am trying to overcome is that our bonds (identified by pool_name) are actually…
Hello. I'm wondering if anyone has ever had a similar scenario/concept and have come up with good ways to achieve the desired outcome. I've attached a screen shot of real data. The goal is to get the submitted date of 7/5/2024 (A6) linked to orders in rows 7 and 8. The story of this data is that order id 16403748 was…
Greetings, I have aggregated transaction data using the Group By tile to produce the following schema: Project ID (GROUP) Amount (SUM) Labor Cost (SUM) I then join this dataset to a list of transactions which are also grouped by Project ID. Left table = = Transaction dataset Right table = = Grouped dataset from above…
I think the answer to the title is you can't, but to get to the point, I'm trying to go from this input to this output: A Group by on Requestor Organization, and another on Phase works as intended on the Preview, and I am then doing a Pivot on the Requestor Organization to turn it into columns, but I'm still not sure how…
I have a singular dataset that includes Live dynamic data, and historical fixed data. For each ProjectId, I need to SUM the PlannedCost of the historical data with a specific timestamp, and SUM the PlannedCost of Live data, so that I can compare the two in Analyzer. Below is an example of the Input dataset for a single…
When joining datasets, Domo alerts you to any conflicts in the naming. Specifically, any common field names have to be renamed. It defaults to using the name of the originating dataset as a prefix. We use longish, descriptive dataset names, and the narrow, static width of the editing line makes renaming very tedious. Is…
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