-
Header in csv files (via S3 connector) keep changing
I have a source that drops a csv file into my S3 bucket daily. I import data into Domo using the AWS S3 connector. The source periodically changes the header names which is super annoying. But now I have rows where there is no data. For example, new files starting 7/1 has a column for "Line Name" but previously, that…
-
8/7 Product Release: Filtering, AI agent 2.0, Navigation, Clonse DataSet, Magic ETL and MORE
Watch quick videos highlighting some of Domo's newest feature enhancements [8/7 release]. Filter & Variable enhancements We’ve updated filters and variables within Domo’s apps and dashboards based on your feedback! Date variables now support 'today' and other relative dates. Also, you can exclude the current period from…
-
Problem in importing an Excel Worksheet from network drive
Hi, I am trying to bring one of the worksheets of an Excel workbook from my network drive. The 'Upload a Spreadsheet' option of 'Connect Data' gives me the below result. Can you please tell what wrong am I doing? The workbook is Excel - Macro Enabled and, otherwise, okay if opened in Excel.
-
Difference in dataset granularity and filters
I have 2 datasets that power 2 table cards: In-stock by Product Branch - this dataset will power a card call "Inventory Inquiry by Product Branch" which has columns: product, branch, available qty, allocated qty, in po qty (= aggreagated sum of all open po transaction) Open Purchase Order Transaction - this will have Order…
-
Require High AI Readiness for AI Chat use with Datasets
Hi, I think it would be a great feature to require datasets to have high AI readiness in order for AI chat to work with them. This would improve the results of the AI chat outputs and would create better data governance around the metadata and definitions. This should be a feature to be turned on/off by an admin of the…
-
Control of Dataset Tags within the instance
The current method of creating tags within Domo is quite straightforward and simple, and probably for many smaller organisations the ability for anyone to create a new tag would be quite useful. The lack of control over the different variations of tags in larger organisations though can result in things becoming messy.…
-
Is there a way to bulk-swap values in Pivot table cards?
I have a few hundred pivot table cards that are using one value (call it Old Revenue). Our data now has a new column (call it New Revenue) that we want to use to replace the Old Revenue value on all of the pivot tables. Is there any way to do this in bulk, or do I have to replace it on every card, one by one? For the…
-
Conversion - String Field to Integer
Hi, I have two datasets that are to be joined by a unique field. Issue is that in one dataset that field is an Integer whilst in the other it is a String. The Join type is 'Left Order' so it is picking the data from the left table but not from right. Can you guide me on how to achieve this / fix this? Can it be done on the…
-
App DB- Dataset sync changed from Scheduled to API update
I am currently using the App DB, which collects data and syncs it to a dataset. Previously, the sync updates were scheduled. However, I noticed that the update method has been changed from "Scheduled" to "API Update." The API update is taking too long to update the dataset. How can I change it back?
-
Allow dataset owners to choose a default date field
When you first create a new card a seemingly random date field is chosen by the card's date selector. At our company it chooses a deprecated field that was populated years ago but is no longer populated. This means that whenever someone applies a date filter such as 'This year' the card shows no data. I am constantly…
-
Dataset sharing not working
Hi, I have a dataset that's dataflow output and I'm trying to share it with another user in my instance but they can't view it. Another user in my instance can view it just fine. I also tried sharing with them the source dataflow and other datasets in the lineage leveraged by the dataflow. It says the user has edit…
-
DomoStats Datasets Field Suggestion
We wanted to leverage a DomoStats for Datasets, particularly the field 'Description', to provide context to the data that exists in our instance so we can leverage AI. Our hope was to use this dataset, get it AI Ready with our definitions/context, and be able to ask an Agent questions like "which dataset should I use for…
-
Point ETL Output to Existing Dataset
I want to be able to point the output of an ETL to a pre-existing dataset. If, as part of a fix or as part of development, I need to make alterations to the ETL to get a desired output that I don't want to be the final ETL, it would be great to be able to make the changes and then point the final ETL to the preexisting…
-
1 customer assigned to 2 sales person, how to show the total correctly?
Customer Sales Rep Customer Current Points Balance Bob a 75 Bob b 25 Tina b 125 Jimmy a 65 Above is an example dataset. I have an APP that has 2 filter cards (Customer & Sales Rep) and a single value card showing 'Customer Current Points Balance'. So that when I select: Customer = Bob → then Customer Current Points Balance…
-
🚦 Tip of the Week #11 – Find Any Dataset Fast with Tags + Filters 🧭
Looking for the right dataset shouldn’t feel like searching for a needle in a haystack.With just two tools—tags and search filters—you can locate exactly what you need in seconds, even in a crowded Data Center. Here’s how to make it work: 🏷️ Step 1: Tag your datasets Add meaningful tags to every dataset. Think in…
-
Please provide Dataset Watchdog Custom Query examples on documentation page
Hello, I'm trying to create an email report using Dataset Watchdog. I'd like it to output the results of a custom query to an email, sent out on a periodic basis. There are no examples to be found on Domo Support or on the Community Forums for how to structure such a query, or what the limitations of this SQL prompt are.…
-
Dayforce data
Curious if anyone has experience automating a feed of Dayforce data into Domo and how you were able to do that. The Dayforce Connector seems either outdated or I just don't use it correctly because the reports I tried pulling in with that are all null except for the employee id column.
-
Is there a way to log data within a Workflow so that it can be appended to a dataset?
I have a Workflow that is looping through invoices, building a table of line items, then sending out the invoices to relevant parties. With each email sent, I want to log the invoice number and the isSent=true variable (created in the Send External Email tile) to a dataset. As it is now, I have the Append to Dataset tile…
-
Export Data Option - Exports WITH Selected Filters
Currently if you are filtering on a dataset and want to export the dataset based on the filters, I don't believe this is not possible unless you create a card with filters or an ETL. I would like the option to export the data with the filters applied on the dataset view.
-
Troubleshooting for Unable to retrieve data error
I want to create a datasetview using some datasources in redshift. However, I frequently facing unable to retrieve data error message while preparing the data. It really being a bottleneck to get my job done. For context, I want to perform simple inner join between Table A and Table B. Table A contains 120 million rows and…
-
"Data Handling" not visible in Config for a Google Sheets Dataset
Hi yall! I'm watching the intro videos on the Domo Youtube channel, and the video on Inputs and Outputs introduced the Data Handling section under the Configuration tab for input datasets in a dataflow. I have a dataflow that changed a column's datatype via a 3-node process, so I thought I would quickly optimize this.…
-
More Efficient YoY Actual to Budget View
Hi Domo Sapiens, Currently, we have a year over year graph that has current year budget also in the series: The bar graphs are each year's actual values, and the line is the current year's budget value. I hard-coded each series with a beastmode, as such: CASE WHEN YEAR(Date) = '2025' AND Actual or Budget = 'Actual' THEN…
-
Sum True
This sounds so dumb and simple. But I'd give my left leg to be able to sum a true/false column and have it give me a sum of True (basically treating it like a 1 and 0) without having to do a beastmode calculation.
-
PyDomo issue to upload data em update dataset
I'm having trouble to upload my data to Domo using the PyDomo API. I read some .xlsx files and aggregate this files in one dataframe with the code below: Then I try to update my dataset using this code: domo = Domo(cliente_id, secret, api_host='api.domo.com') dataset_up = domo.ds_update(dataset_id,df_final) However I keep…
-
Federated dataset: can I prevent a non-filtered preemptive query?
I am using a federated dataset (SQL Server) with hundreds of millions of records, for thousands of users. It appears that Domo retrieves or queries the entire data set before any card is displayed, resulting in tremendous resource usage. When a user views the card, I am providing a filter that restricts the query to one…
-
Splitting up multiple-value fields into multiple rows
Hello, I have a dataset like this: ID Num 1 10 2 20, 30 3 40, 50, 60 I want to use Magic ETL to break these out so each row has one "Num": ID Num 1 10 2 20 2 30 3 40 3 50 3 60 Thank you
-
Allow manual refresh of Cloud Amplifier / Federated dataset schema
I would love a quick 'Run Now' button on this dropdown for Cloud Amplifier and Federated datasets. When building new models where I'm making frequent changes and adding cloumns, I have to wait and wait for the schema to auto refresh from the database for my data to show up again. I think the main workaround now is to lower…
-
Issues Regarding Data Type Specifications in Domo Workbench
We are experiencing the following issues with data type specifications when connecting data using Domo Workbench. The attached image shows the results of our tests when connecting data to Domo via Workbench. The "number_DOUBLE" column is of DOUBLE type, and the "number_DECIMAL" column is of DECIMAL type. Please note that…
-
DataSet Folders
As our dataset count in Domo grows, managing and finding the right ones is becoming more challenging. Right now, everything sits in a single list in the Data Center, and while filters and tags help, they’re not enough for long-term organization. It would be a huge improvement if we could group datasets into folders,…