-
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.
-
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…
-
How to append data so you can get a snapshot every time your dataset runs
Hi I have created a date field in my dataflow using this formula to give me the current date: DATE(TODAY()) I am trying to use this date field to get a snapshot of the data every time the dataset refreshes. I have my dataset scheduled to refresh every Friday. The first Friday the dataset refreshed it gave me the correct…
-
Changing dataset update method from Replace to Partition doubles data
We've noticed that if we change the update method of an existing dataset to Partition from replace, we end up with two records in the dataset for every new one (and both of them look identical, down to the field we're using for partitioning): it was quite the shock to see a dataset I expected to have 91 million rows…
-
Managing Data Retention Policy
Currently, there's no feature to create and manage custom rules for handling historical data within datasets. Companies have specific rules on how long they are allowed to keep different types of data and it looks like it is not easy to enforce this in Domo. There should be settings in DataSets where we can define…
-
How do I set up the append option for updating data correctly?
Use case: I have callrail data that begins in 1/1/2021. Currently the dataset is updating everyday and has REPLACE as an update method. The dataset is now taking at least 1-3 hours to update. I thought about changing the update method to append but when I did, I had duplicate data from 2021. How can I change the update…
-
best way to replace a subset of data
I have a large historical dataset to which I append records at the end of each day. I have been asked to correct the distribution of values for a small subset of the data over the past nine months. I can use the data repair tool feature to remove all of the data imports for that time, but this would force me to destroy and…
-
Is there a way to disable auto refresh of a dataset?
I want to stop an API data set from ingesting further information going forward as it is getting replaced with a different dataset. Is there a way to stop the data set from making API calls and ingest new information?
-
Numerical Dimensions/Attributes
Add a column property to allow numbers to be defined as dimensions/attributes rather than forcing them to be measures. Common examples are ID, Order Number, Employee Number, etc. Sort, display, justify them as numbers, but do not aggregate them to a meaningless value. In other tools I have seen this as a simple checkbox.…
-
Color code table columns based on tags
Our privacy officer wants us to start tagging table columns that contain PII. The problem with that is that when you add a tag to a column the only visual indication a tag exists is the information icon (a lower case "i" in a circle). We would like to: a) assign colors to tags so that when they do display the color is…
-
Provide details on when Domo will attempt to run a dataset again
As an Admin or Editor I want to see the details of when Domo will attempt to run a dataset again. In order to know if I should try to manually kick off a dataset, or wait for Domo to run it. Currently the Interface shows this when there is an isssue: When clicking view details, it takes you to the History tab. I would like…
-
Trigger a dataset update via python using a post call
I am currently successfully triggering a dataset update from Snowflake to Domo via python using the following code: import requests #list of dataset ids and stream ids for the Snowflake>Domo connections guids = { 'datasetID': 'StreamID', 'DatasetID2': 'StreamID2', } #Does the work of kicking off updates for all Domo…
-
Is there a way to mass update sharing settings for mutliple dataset?
Hi, I need to remove user & group access from 100+ datasets in Domo. Is there a way to do this en masse without clicking on the detail view for each dataset and managing sharing settings individually? Any tips would be much appreciated! On a separate note, I'm not sure why certain users & groups suddenly gain access to a…
-
Resize elements in Dataset Lineage View
As a Domo user I want to be able to resize the right-, and left-hand navigation elements in the Lineage view of the dataset. /details/data-lineage In order to view the full name of datasets that have long prefixes. In the example below, datasets prefixed RAW_WebsitePerformance_GoogleAnalytics_****** you cannot…