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.