-
Direct Query against on-prem source
Can Domo perform a direct query against an on-prem SQL Server instance? For example, if I have a database named "SalesDB" on my local SQL Server, can Domo connect to it and run a query like "SELECT * FROM Orders WHERE OrderDate > '2024-01-01'" directly? I thought workbench would've have that option.
-
Dataset with column labels
Is there a dataset (like DomoStats or Domo Governance dataset) that has info on column labels? I.e. what the columns on a table are labeled as (not the actual field names from the dataset). I'm trying to make some sort of tool for users to filter by labels used on report elements (not the actual column names, which aren't…
-
Is there a way to track which DOMO assets (cards, datasets, dataflow, etc) uses a specific field?
We found the Card Fields & Beast Modes Governance dataset which shows what fields are being used in cards and beast modes but we would like to track a field name from it's original dataset > name change (if it applies) > DOMO asset.
-
Add a place to put a link to data source
I would love to have an area in the data connector where I could put a link to the data source. This could have the same visibility as the description/tags/owner/etc. For example, if you are viewing your Sharepoint datasets in the data warehouse, you could see the name, description, etc as well as a direct link to the file…
-
Notification when dataset or dataflow runs
Hello, Have some clients asking about an alert when a dataset or dataflow has completed. Currently we just have failed notification but clients would like to get a confirmation on vital dataflows/datasets completed, during immediate need moments. Helps when we are using the DOMO cloud to pull data from DOMO into other…
-
Budget to Actual - Multiple Dimensions & Different Datasets
I have a budget dataset with the following columns: _Account _Subsidiaries _Department _Doctor _Location (Not in Use) _Headcount Resources _Placeholder 4 _Year _Period _Scenario _Currency _Measure _value I have an actuals dataset with the following columns: Appointment Date Status Appointment Type Patient Account Number…
-
Domo User Groups & Dashboard/Dataset Sharing
If we share a dashboard with, say, the Default group, all current and future people added to that group see the dashboard (as expected) However, the underlying dataset that powers the chart(s) on the dashboard only gets shared (individually) with the users who were part of the group when the dashboard was initially shared.…
-
Compressed (zip) Foler upload with 2000+ csv's, best way to upload and append all?
I am trying to upload around 2500 csv's of historical data into Domo to then compile into ~8 total files (they are deliniated in the file name of each output) and I can't seem to find an efficient solution to do this without uploading them individually. Any ideas? Thanks!
-
Hashing Data in Domo
I need to generate a file with PII data but we want to hash the data before downloading. Could anyone point me to the right direction on what can be done in Domo? the data is in Domo.
-
Explicit export permissions on Domo datasets
The primary goal of this feature is to provide organizations with the ability to control export permissions at the dataset level, ensuring that only specific datasets deemed necessary for export can be exported by users. This granular level of control will help maintain the integrity and confidentiality of sensitive data…
-
Change Data Capture (CDC) on Domo Datasets
It would be useful to have CDC capability on Domo datasets, creating a journal file of all changes to a dataset such as deletions, insertions, updates so that they can be tracks and potentially acted upon.
-
Multi-Value Card - Revenue and YOY % Change
Hello Community, I need help creating a multi-value card in Domo to show total revenue and year-over-year percentage change based on filter selection. The requirements are: Yearly Comparison: If for example FY25 is selected, show FY25 revenue and compare it with FY24. Similarly, for other fiscal years. Monthly Comparison:…
-
Tagging Customers on Services
Hi Community, excited to see what you think up! BLUF: How can I analyze what nurse saw a patient prior to a surgery or a non-surgery? See my simplified dataset below. My hope is to be able to see which nurses saw which patients/customers that led to a surgery (or not). My current thought is a CASE WHEN to create a label…
-
Olo Data Connector
Has anyone connected / created datasets from Olo? I have created the account connection but the help file on the Olo connector doesn't match the panes described…
-
Domo Packaged Apps Activity Visibility
I would like to see the Object ID's and their respective activity exposed in DomoStats data sets. As a specific use-case, we are looking to identify all associated Datasets, Cards & Pages embedded in Domo Campaigns, and their respective recent activity, to influence our archiving processes. At the moment, this is a…
-
bar graphs incorrect visuals
Hi, I am experiencing an issue with Grouped bar graphs. The x-axis is duplicated with the items, despite the data is seen correctly on Data Table (inside analyzer) and also when put on a HTML Table. Using beast mode calc for values. The category column is straight from the dataset.
-
NULL value Handling
I'm a bit frustrated by this one. I have done everything along the path to ensure NULL values are being handled appropriately in my data. Starting from flat files and ending in a dataset (with several non-Domo steps in the middle). All of my data appears as expected in the dataset, but as soon as I add the column to a card…
-
Dataset/Dataflow update trigger expirations
It would be very helpful, especially as customers move to consumption, to have advanced dataset update controls to have triggers expire. As an example, I have survey data that I want to update frequently during the survey window, but then stop once the survey has ended and no new data will be added. Right now my option is…
-
multiple Groups shown in just one column
Hello DOMO - Good Day! I am using the Data governance dataset that has the users and groups. what we wanted to show is the pages/dashboard and then all the groups that can view it. currently, I can show the different pages and the different groups in different columns. just wanted to know if we can show all the different…
-
Why are published datasets presenting to subscribers as federated?
I have an excel dataset in the parent instance that I've published to a subscriber instance that shows up in the subscriber's instance as federated data which prevents the subscriber from doing anything but creating cards from that dataset. There is one PDP policy set up on the excel dataset in the parent instance so that…
-
Errors caused by Timezone, Where can I adjust it?
I found the dataset in DOMO is different from the raw data in google sheet for DATETIME field probably due to time zone different. Where can I adjust it? thank you so much.
-
How to Export filtered dataset?
I have a 1 million row dataset in Domo. I want to filter the data, and only export that data in a CSV. When I filter the data and export, Domo exports the whole 1 million rows, which does not run on my Excel. Anyone know how I can download the filtered dataset>
-
Extract/Export metadata information of entire DOMO App/Dashboard in Json/XML etc file format
I created an entire App/Dashboard end to end having lots of widgets including texts, images, layout, text, cards for visualising a particular dataset which I have created say using Database Connector/File upload What I want to extract/export the entire Dashboard metadata out of DOMO in some file format being it in Json/XML…
-
Troubleshoot: Domo is ready, but an email was received that did not contain the specified file type
Domo is ready, but an email was received that did not contain the specified file type. Ensure the File Location and File Type settings are correct then try again. I am getting the above error message for a dataset that is coming into Domo via Email attachment. Here are the settings: skip empty rows is also unchecked at the…
-
Data sharing rules
Once data is shared to a group, we currently have the situation where users in that group can share data to individuals. Thereby 'breaking' the concept of having the group. We need a way to stop that from being able to happen. I know current way of working is standard DOMO, but for us (particularly in relation to any…
-
Google Sheets connector datasets failing due to auth token expired.
Hello, I am seeing that something today happened for all of our google sheet datasets via connector are failing or having long run times due to this error message. "Domo is ready, but the authentication token is expired. Please verify your account credentials and try again" Does anyone know the resolution for this? I tried…
-
Dataset Direct Impact Reporting
In Data under the Overview tab, there is a section called Direct Impact. This data is very useful when doing Dataset maintenance as it will give you an idea of how that data is used. We would like to see this data reported in Domostats | Datasets so it could easily be pulled into any reporting that might be highlighting…
-
More query params for ListDatasets
Endpoint: https://api.domo.com/v1/datasets (GET) As a data engineer, I am trying to programmatically list multiple datasets using specific parameters. When I use the UI, I have multiple filters such as Last Run, Type, Owned by, etc. However, the datasets API only supports 'namelike.' It would be awesome if we can use the…
-
Approvals in-progress tracking
I love that each approval flow spins up its own dataset to track completions, but approvals only seem to show up after they've been completed with an approved, canceled, or denied status. It would be lovely if the dataset included any submission even if it's still in progress to better identify at which stage an approval…