-
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.
-
Filter Cards List by Dataset
As admin, I would like to be able to manage large groups of cards by dataset. Currently the cards view can be filtered by owner and/or page but not the dataset, which would help me manage the content of a particular dataset more easily.
-
Is there a way to create a chart that displays the percentage of null values across all datasets?
I want to know the percentage of null values across all datasets that we have, I am not interested in one particular dataset, I want to know the overall percentage.
-
How to erase all contents in a dataset without deleting the dataset
Hi, I have a data connector through the "DataSet via Email Connector" that reads the attachment from an email. I need to empty the dataset without having to change the email address. Does anyone know how to do it? I can delete this dataset and recreate one but I would prefer to keep the email address to avoid additional…
-
Sankey & Sankey Path Data Structure
Hi all, I am building a sankey chart to show the flow of transactions. Ideally I would like to use the Sankey Path visualisation. My data is structured with column names: from, from_type, to, to_type, value There are 4 stages to the flow. I would like to be able to filter the visualisation to show the flow for certain…
-
Demo Slam: Dataset Access Requests
Hi All! Hope you enjoyed my demo in the first ever Domo Demo Slam today. Here is a link to it if you missed out: As promised, here is the step-by-step write up to replicate what I've done in my instance. Enjoy! P.S. this is version 1, version 2 will include more data exploration options for end users. 1. Set up the Domo…
-
Dataset Groups
I would love to see a more organized way to group datasets together and limit the number of datasets that are in view during a search. We have too many datasets with similar names and it gets difficult to find them sometimes unless you remember and search the full name.
-
Is possible to made a "not in" condition in PDPs?
Usually I use PDP giving access to some areas, but for exceptions I can not just give access to everything, like Employees of Area A but not access to a specific employee out of 300 is posible to use a not in for a PDP?
-
Comparing Datasets to Determine Variance
Hello everyone, I am working on comparing data from a previous data input, Universal Analytics, to a new one, Google Analytics 4. Basically, there was an update and data is formatted differently. I am attempting to join the two datasets to compare the month of A ugust for variances, but the closest thing to a unique column…
-
Mimic Vlookup in Dataset?
As the title says, I am trying to mimic a vlookup on a dataset. I am using an ETL that is connecting different membership logs from SF. Basically every time a member leaves or joins it creates a new log. On one dashboard we are looking at data based on all the members who joined this year but also left this same time…
-
Dataset to display the underlying DB table/view in Overview Tab
It's good to know the underlying databse table or view on which the dataset is created in order to backtrack any issues. In case developer of the dataset leaves role/org it's difficult to find the datasource table/view name.
-
Warnings for Exports w/ .xlsx that are over 100,000 lines is Gone - please reimplement
For the first 3 years at Domo there has been a warning about exports over 100,000 lines for .xlsx saying "there are possibly missing lines of data as you have reached the max data exported via .xlsx." The issues for us here is that people are going to be working with large data sets and then never know that data is…