-
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.…
-
Dataset ownership for users groups
Being able to designate groups and/or several people as owners of datasets, dataflows
-
Ways to visualize datasets impact beyond first level
The direct impact and total impact information (about datasets, dataflows, cards and alerts) is only available by consulting the elements individually in the Domo interface, however it would be very useful to have this data in the DomoStats tables. The main use case is for the platform owners to have a centralized place…
-
Is it possible to calculate ROAS and WoW change in the same beast mode formula?
I'm working on a pivot table and I want to show the % change of ROAS from last week vs. two weeks ago. My dataset does not contain a 'ROAS' column so I'm trying to calculate it within the WoW beast mode formula. If I breakout the formula below into two parts (LW ROAS vs. 2WA ROAS), the first part will correctly give me…
-
Need to see which connectors are currently connecting
I need a way to see which connectors are currently executing. Ultimately, I'd like to have a card on my error dashboard showing which connectors are running, how long they've been running, and possibly the average execution time so we can know if something's out of whack. Is any of this information surfaced in DomoStats or…
-
Removing or anonymizing PII data?
Is there a best practice approach customers are using to remove or anonymize PII data for former clients? (tools, other clients who may have done this, etc.)
-
Add Dataflow Comment to Domo Stats | Domo Governance
I would like to create a card showing the changes to dataflows and the description. I have looked in domo stats and also domo governance and don't see it. I am looking for the comment you add before you save. Not the description of the dataflow that you put along with the title.
-
Different Page Background Colors for DataFLOW page and DataSET pages
Yes, I know I should know when I'm in a DataFLOW page vs. the DataSET page. But I don't. And it's confusing. Change the background page color when I'm on each so visually I don't have to look around to see where I'm at. Doesn't have to be bright crazy colors. Wouldn't that be helpful?
-
Integrating different social media platforms reporting
Is there a way I can extract data/metrics from all social media accounts (LinkedIn, Facebook, Youtube) together? I use connectors to extract data individually from each social media connecter. But getting all metrics in one Dataset can be helpful in getting a better visual view.
-
Ability to Edit Virtual Dataset Jobs
The ability to edit virtual dataset jobs would help a lot when working between production and sandbox environments. We would like to group our virtual dataset jobs by data domain, to help make sure we don't end up with duplicate datasets in our production environment. However if we create a new dataset we currently cannot…
-
Data exploration beyond what users have access to
We are practicing the principle of least privilege and only sharing data to users if it is needed for their role/department. However, we would like users to have the ability to see what other datasets exist in case there is data relevant to them. I used domostats/domogov datasets to create a table card that is somewhat…
-
Need help mimicking recursion with partitioned datasets
I need help implementing a particular use case for partitions: importing selected partitions from a dataset, modifying the records, then outputting the data back into it's original partition (or a new partition) in the original dataset. There are two uses for this I can think of off the bat: A dataset can have a maximum of…
-
Card not reflecting updated Dataset/Dataflow updates
I manually run the input dataset that feeds into the datasets of 3 other dataflows. And all 3 dataflows reflect the inclusion of new data, but this is not reflected in the cards' visualization, as in the cards are reflecting data from the previous update despite the dataflows reflecting data from the new update. Any ideas…
-
Selecting only newer records from a remote datasource to append to a Domo datasource
Hi here… When setting up a query to grab data from a remote datasource and append to data in DOMO. Is there a way to grab newer records based on the data that was previously imported. Page: DATA / <DATASET NAME> / SETTINGS / QUERY I'd like to run something like: SELECT * FROM myRemoteDataSchema.myDataSet ← remote dataset…
-
Dataset with custom managed attributes for users
Domo now allows custom attributes to be created to capture additional user details. But there seems to be no dataset that provide details on these custom attributes. It would be useful if a dataset/api/other consumption method was available through which this detail is accessible. As this will greatly help us to validate…
-
Calculating a final value from two selected values that exist in the same column?
I have two columns—one column has revenue, the other column states which quarter the revenue was collected in. Is there a way that allows a user to select a quarter to calculate the difference in revenue between the selected quarter and another selected quarter. So, I am basically looking for a solution that would enable…
-
Multi-tab input
Hello, I have a input data set that is a multi-tab spreadsheet. I used File upload option to import that to Domo. When I am using this in Magic-ETL, I am unable to specify the tab that I need.. What is the way to specify the exact tab I referring to in that spreadsheet. I need to use different tabs for different joins in…