Ask Magic ETL questions and get answers from Domo peers
I currently have an ETL looking at distinct Opportunities by their close won day. However, this issue is now looking at Distinct accounts within the same dataset. At first, I thought to use the count distinct function on the account ID in a groupby. However, since multiple opps can be tied to one account and each one can…
I have a dataflow that I only want to start when the data in a dataset materially changes. It seems like it runs no matter if the data changes or not. Any advice on this.
Hey there! I am trying to alter a text into a date, but I keep getting the "failed to parse" warning. For context, I'm uploading a CSV file. Does anyone know a formula to fix this? I've tried multiple, but haven't had much luck. *I provided a screenshot of how the field looks in the CSV file prior to uploading into Domo.
Hi, I am facing below error while executing magic ETL flow in Domo. Failed while executing "Failed to index DataSet '3a922bde-7139-42c1-96c3-88d7516a1fa7' " All tiles were executed successfully, but output dataset is not created. I used "upsert" as update method for creating output Dataset. Could you please suggest to…
Hey there! So, I am trying to alter a text into a floating decimal but I keep getting the "failed to parse" warning. For context, I'm uploading a CSV file that already has the field I'm needing as a currency. But, when I upload into Domo it turns it into a text. I will be needing to aggregate (sum) this field so I need it…
Hello, Is there any way to import a dataset created in Power BI (via Power Query) into Domo as a dataset? For example, my organization uses a Data Warehouse (other than domo). The Finance group, which uses Power BI performs transformations on the data from the Data Warehouse. I would like to use the 'processed' datasets in…
Hi everyone, I have the below data example: Name Variety Benchmark Value Achieved Value Apple Red Apple Batch 23 3 4 Apple Red Apple Batch 22 N/A 4 Orange Batch 11 v1 3 4 Orange Batch 11 v2 5 3 Pear Batch 20 TVS 2 6 Pear Batch 24 LKT 4 1 Plum Batch 25 MBH N/A 7 Lemon Batch 2 N/A 5 Ideally I would like to use colors on a…
Hi DOMO Community, I am working on a project where I need to look at running totals. I have the following beast mode function written out and it seems to be working properly so far: Now, I want to try to fill any null cells. My original approach for this was to create a new beast mode called Incurred During Period where I…
I'm looking for actual documentation of the DATE_FORMAT, DATE_TRUNC, and TIMESTAMP_TRUNC functions.
Hi, I have a magic ETL dataflow. It has 2 input sources. There's a formula tile where we calculate a pacing percentage. (`Delivered Impressions` / (`Campaign Flight` - `Days Remaining`)) / (`Total Goal` / `Campaign Flight`) We've been using this dataflow and formula without any issue for months and now we're getting this…
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