-
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,…
-
Magic ETL Won't Save DataFlow?
Team, I have built an extensive ETL and I want to "Save and Run" to explore and analyze the output. Unfortunately, the "Save" button isn't responsive. I will click on it and it won't actually save. I'll click "Save and Run" and it won't actually save… Weird issue that I've never ran into before so hoping there's a simple…
-
Change Certification from Datasets to Dataflows
Certification is currently requested and managed via a dataset, however we've found that in some cases changes to the dataflow don't cause the certification to expire. This introduces potential risk in cases where changes could be made that affect the accuracy of the data, but the dataset could still be flagged as…
-
Two Data Sets, Differently Named Fields - Unable to create paired filter for dashboard cards
Domo community - need a hand on this one. I have two datasets: a) Client records (note: uses client UNID of "SGId") b) Events related to the Clients (note: uses client UNID of "ShowGroupID") Both sets have a common UNID that identifies the clients. One is named SGId and the other ShowGroupID as noted above. For the B data…
-
Dynamic Currency Symbol Formatting
Currently in Analyzer, number columns can be formatted as currency, allowing you to append one of 4 currency symbols to the beginning of the number in the chart. It would be incredibly useful to add a dynamic currency column option. Rather than having to select 1 currency symbol for the whole column, you could select…
-
Error when committing and promoting to another instance
When I commit my repository I am getting a generic error message with no actual id's to reference: Invalid content entity could not be added as a dependency of {contentType} with id {contentId}. Clicking the blue contendid takes me to two cards which have no errors. What could be causing this?
-
No Credit Charges for DomoGov/DomoStat Datasets
I'm an avid believer in utilizing business and technical metadata to train, govern, and administer business intelligence. The primary reason for selecting Domo for my new company was it's ability to visualize the full-stack data journey (Connect→Warehouse→Transform→Visualize→View) through metadata. This became the focal…
-
How to edit Data Assembler jobs
hello, How can I edit a data assembler job in domo? For example if I want to change the setting or create a new one?
-
SQL Connector dataset set to 'Replace' but the data remains the same
I am using the preferred SQL Server connector and pulling in data. However I want to "restart" this dataset and wipe it out to 0 rows. I set the update method to Replace and modified my query to return 0 rows. I can see my preview returns no rows: However when I run this, the updated rows shows - and the total row count…