-
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…
-
Data transformation ideas around old/new user data
HI, we're migrating from username sign in, to okta that uses email as user id. we have an existing user info data with user id as username (xfsgsbss) but we would have a new data with user id as email(fdhsvbsjsbsjsh@email.com). I want to be able to join both old and new data and make sure the right attributes goes to them,…
-
A way to identify/report on hidden datasets
Found out that when users add certain full service apps from the appstore to your instance, it can result in "hidden datasets" existing in your platform. These datasets aren't visible in the datacenter, nor do they appear on any Domostats reports. Per support, Domo has an api endpoint that can be searched by dataset owner…
-
How to create a rate by specific selection criteria in Domo
Hello again community. So I work within a healthcare organization and I have a domo grouped/stacked bar graph built currently from an etl that has columns regarding patients readmission start date, account number, discharge date and attending providers(previous admission). The card breaks down the readmit percentage rate…
-
Effect of DataSet View Calculated Columns on Performance
I want confirmation that if I shift over a bunch of dataset view calculated columns to run in the dataflow instead of on the dataset view that I can potentially boost the performance of my dashboards. Currently, the dashboards run okay, but filtering takes a while. The dashboards are heavily leveraging COUNT(DISTINCT()),…
-
Does the API's dataset/export method work?
I'm building a PHP client library for Domo, and I'm currently having trouble with one of the endpoints. Specifically: API Docs: Endpoint: /v1/datasets/{dataset_id}/data Method: GET According to the documentation, if I call that endpoint with the GUID of a dataset, it should return CSV content to me in the response body.…