-
Is it possible to batch edit source data?
I have a large dataset that needs some cleaning. We have appended to this dataset daily over several years and some of the data values have drifted over time as users have renamed what are essentially labels for different entities. If this were SQL, I could write an update statement and quickly replace the values in label…
-
Extracting Data from SharePoint Excel spreadsheets
Hello everyone, I'm in the process of setting up financial reporting in Domo. Our FP&A team processes financial data and then stores it in two specific Excel sheets within our SharePoint. I'm looking for the most effective method to extract this data into Domo, creating a dataset that can automatically update with new…
-
Retrieving Data from a partner's Domo sit
Hi everyone! I have been using Domo for a little under a year. Today I realized my organization pulls data from one of our partners domo dashboards manually which is then uploaded into our domo data each month. Is there anyway to create a pipeline between two organizations Domo sites to feed our datasets?
-
Recover a deleted dataflow
Hi, I was doing some cleanup and deleted some datasets that resulted in the deletion of a dataflow. Is there a way to recover deleted dataflows? I noticed a deleted dataflow could be recovered if you find a link to it: —but I can't find a link to the dataflow I need. Thanks.
-
GA4 Weekly and Monthly data - should I schedule a better import or make an ETL?
I'm not sure which direction to take - has anyone dealt with GA4 weekly, monthly, and yearly datasets before? I've realized that if I need to get a summary number of users over a certain time period in GA4, the only true way to make sure they are not double counted is to make separate datasets that pull in users by day, by…
-
DataSet Scheduling Hub
It would be nice to have a centralized place to view and manage the scheduling for all existing DataSets.
-
Favorite Datasets
It would be very helpful to be able to "Favorite" datasets like we already can with cards and dashboards. This would make it easier to find your most used datasets when building cards, especially with similarly-named datasets. While it is possible to accomplish this using dataset tags, it would be challenging to manage…
-
Required Role Level for Reverting Dataset History
Hello, Domo Community! I'm in the process of delegating dataset management tasks and need clarity on permission levels. Specifically, I want to understand the minimum role level required for a user to access the history of a dataset and use the "revert to this point" feature. I've developed some reports and plan to allow…
-
How to disable SQL Editor on a View once it's been enabled?
I enabled the new SQL Editor on one of my views this morning to troubleshoot an issue: it's a wonderful tool, and helped me solve a very bizarre problem. Unfortunately, the editor takes up a lot of screen real estate, so I would like to disable it and return to the normal form of the view now that it's no longer needed.…
-
Domo Buzz Dataset
Is there a dataset, or a way to get the data from buzz?
-
Calculation error: Duplicate calculation name
Over the past few days, I've been facing the issue of a calculation error: Duplication calculation name. I believe that other DOMO users might have also be experiencing this issue. Despite having different datasets, when validating a BM with the same name, a duplication error occurs. This problem started occurring a few…
-
Unable to save view
What could be issue with me being unable to save a view? I know it's not permission or browser related
-
Connecting to a large dataset available for download
Hi All. I am working with try and connect to a few HMDA data sets that are available and am not sure how to do so. I remember a consultant we had connecting to data from a federated data source but also, not sure if that is what we are needing to do. More specifically, we are trying to connect the Loan/Application Records…
-
Expanded Options for Dataset Alerts
Datasets often require monitoring that is complex. My idea is to make the dataset Alerts more dynamic, so that an Alert could be sent in case the dataset row count did not change, or if another undesirable outcome occurs. We occasionally experience an issue where the dataset updates successfully, but the row count does not…
-
Assistance Required with Locking DataSet in DOMO
Hi everyone, I am currently in the process of uploading an Excel dataset to DOMO and am seeking guidance on a specific functionality. My objective is to restrict access to this dataset, ensuring it remains confidential. While I have noticed the option to lock cards in DOMO, I have not yet found a similar feature for…
-
How to create a recursive dataflow with multiple unique dimensions?
I am working with a dataset now that several unique components, including date. Within a given day, there are about 12-15 new records produced based on these dimensions. I tried creating a unique identifier that concatenates these dimensions (including date) with the hopes of creating a unique ID that will distinguish old…
-
How to find out shared datasets
I am looking for assistance in understanding access permissions for multiple datasets. While its straightforward to check access for a single dataset through the share option. I am uncertain about how to determine access for multiple datasets. Is there a way to identify the users with access to multiple datasets? Thanks
-
Meltwater Connector Data Visualization Ideas
Hi All, Hoping to get in touch with any Domo users who are interested in sharing ideas around Meltwater (social & media intelligence) platform connector cards. Let me know! Any successes or best practices? We just onboarded the new platform across our brands. Thanks, Paul
-
How do I construct my desired query?
I am creating a card in DOMO, and I am trying to query from my dataset. I want to query in such a way so that I first query the dataset only for its column names, then I use the column names to query all the data in the dataset. This is what I have so far: I am getting the following error, however: "Uncaught TypeError:…
-
Can I dynamically query all fields?
In the javascript for my DOMO card, this is how I am currently querying from my dataset: If I am simply trying to query all the fields in my dataset, is there a way I can avoid hard coding all the fields in the "dataColumnName1" variable, and just change the "query1" variable to dynamically query all fields? Thanks.
-
Can I restrict the datasets that are available to end users accessing Domo via API?
Good evening, I have end users looking to access our data in Domo via API. At the same time, I want to restrict which datasets they have access to. I thought I'd solved this by creating DataSet Views, restricted to the user's particular slice of data (for example, there's a column called "user name" and I filter the…
-
DataSet via Email Connector - Using the Email Address to find the Dataset
Hi All, I have a "DataSet via Email Connector" email address (a1b2c3d4e5f6@example.mail.domo.com), but I don't know what dataset it connects to. How can I find the dataset that the email address belongs to? Thanks
-
I would like to do predictive lead scoring for my data
Hi, I have a dataset with the leads information (demographic, titles, etc..). What would be the way to build the predictive score in Domo? For example, Domo can help me predict the score of this lead based on the assigned columns. Thank you for your help!
-
Not sure why I am getting a SQL Error
I have the columns correctly added, but even though its there in the columns list, I am getting an error. PLease check the screenshot to view details
-
Usage of Domo for HR data ideas/best practices?
Hi All, We are contemplating expansion of Domo for HR data, specifically using UKG. Any best practices or cool stories to share about what your company has done with Domo for HR data/dashboards? Paul
-
How can I copy PDP policies from one dataset to another?
I have a dataset I needed to recreate for various reasons from an existing dataset with pdp. i want to be able to copy the pdp policies from the orig dataset to the new dataset. How can I do that?
-
Dataset Views - JOIN on date range?
In most database systems, you can create a join/view on date ranges like so: SELECT * FROM A1 JOIN A2 ON A1.ProductID = A2.ProductID AND (A2.SalesDate >= A1.StartDate) AND (A2.SalesDate <= A1.EndDate OR A1.EndDate IS NULL) However, a DataSet View in Domo only seems to allow joins on exact values and does not allow ranges…