-
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…
-
Improve mass data set change on cards
When creating a new dashboard my team frequently needs to duplicate an existing one, including cards, and then update the data source for each card one by one. The current system only allows users to migrate ALL CARDS associated with a data set. If I duplicate, I have: the originals the dupilcates I just want to migrate…
-
Is PyDomo appropriate for my data update work?
Hello. I've been reviewing different methods of updating data in Domo. I'm currently using Workbench, but am considering creating a completely hands-off setup using PyDomo. So, here's my scenario: We have a number of datasets that originate from ServiceNow. I put those through some local processing using Python scripts,…
-
Disable Automatic Archiving for "Inactive" Datasets on Individual Basis
Domo will archive inactive datasets if they have not been accessed in over 30 days. Domo defines "accessed" as not being "used and viewed regularly in Cards or Dashboards".* We have several datasets that exist for use outside of Domo. These datasets are only accessed via API. This means our datasets will be archived due to…
-
Total Rows In Datawarehouse
Hi Experts , I need some inputs on the no of rows showing in Domo DW . It is showing 214 M rows ,I deleted unused datasets ,connectors and limited the no of rows for some datasets . It is still showing as 214M rows ,is there anything I can do to reduce the no of rows ? Also , if you can clarify that if I use Dataset A for…
-
Dataset Stats Page - Filtering
When looking at a dataset, you can select the Stats to review the distribution of values, presence of nulls, etc. When you filter the data before navigating to the stats page, it filters the first 2 sections of information, but not the third. Section 1 - Uniqueness and Nulls - Filtered Section 2 - Graphical Distribution of…
-
Bulk Edit - Additional option for Schema Tab
Under the Bulk Edit feature, would like to see an additional radio button for "Edit Schema settings" For the Schema tab would like to have options for To update the option “Block all Schema changes” to update the check box next to “Protect” (in column header) While upgrading from the older version where these options were…
-
I want to host a webinar on how to automate all manual uploads into DOMO
If you find yourself spending an hour or more every week manually tweaking and uploading data to DOMO, I want to help show the DOMO community how automation can help streamline your efforts where a connector or integrations don't exist or resources are not available. If this sounds like something you would be interested in…
-
I want to host a webinar on how to automate all manual uploads into DOMO
If you find yourself spending an hour or more every week manually tweaking and uploading data to DOMO, I want to help show the DOMO community how automation can help streamline your efforts where a connector or integrations don't exist or resources are not available. If this sounds like something you would be interested in…
-
Bulk scheduling for datasets
We have some credentials that are no longer valid for reasons beyond our control. This is leading to 50 datasets failing every day until this is resolved. Anyone know of a way to perform a bulk action to disable all of these datasets until the credentials are fixed?
-
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.
-
Give Schema Management Toolkit the ability to set a default value when adding a new column
When you add a new column — via Schema Management in the toolkit — to a dataset that is either partitioned or updated by appending, it would be nice to be able to set a default value for the column so you don't have to go through contortions to update the older records.
-
Comparing one month's EOM data to previous month EOM data in same row
Hi, I need to do a calculation so I can subtract previous months hours (4/31/2023) data from this month's hours (5/31/2023) data. This is how data is organized. This just a small example of how it is. Without changing the structure of dataset how can i get all the 4/31 data on the same row as the 5/31 data? I have been…
-
How can we stop the dataset from disabling with time automatically?
In such cases when dataset is not being used but we also do want it to disable automatically , is there any way to keep it running over the period of time???
-
Properly Writing Back to Output?
Hey, first time Domo Jupyter user, and a new Python user. I'm having a difficult time exporting my data to a new dataset. From this: I keep encountering this error: /home/domo/.conda/lib/python3.9/site-packages/domojupyter/io.py:125: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future…
-
Is there a way to dynamically select the nth row of a table?
I have a table that is part of a drill path. The table is filtered by a bar chart that has a category and numeric value (x). I want to select row (x) from the table after it has been filtered. Is there a way to make this part of the drill path?
-
Calculate Previous Year metrics in DOMO
I have a requirement to calculate previous year's data (in monthly format - Month Over Month). So if user selects Fiscal year 2023, he should be able to get data for 2022. Only catch is that 2023 means Oct-22 to Sep23. So 2022 would mean data comparison between Oct-21 to Sep22. Any help would be greatly appreciated.