-
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…
-
Connector Version Identifier or Notification
It would be great to have the version of the connector displayed in the overview tab of a dataset to make sure it is always up to date or to have a notification when it needs to be updated.
-
Card that will show if a Dataset has been updated
Hello DOMO - Good Day! I would like to know if it is possible to create a card that will show if a dataset has been updated? also, if it has been updated automatically or manually basically, a card that shows the dataset name, the date it ran, and if it is automatic or Manually ran. Thanks
-
Alerting on Non-updated Dataset
Howdy! I am trying to create an alert on a dataset coming in through the email connector for when it doesn't update after 24 hours, for example. The dataset doesn't fail and therefore send a notification email because there is no email coming in to fail. But the dataset is no longer up to date and the connection needs to…
-
What to Know Before Implementing Domo Certifications
Hello, my team is looking into using the certification process in Domo for the first time. Our goal in using it would be to better organize and manage our instance, to easily identify our forward-facing assets, and to make clean-up of junk cards and datasets easier in the future. I was wondering if anyone has used this…
-
Unknown Domo Governance datasets run error
Hi all, I've recently started looking into collating the masses of beastmodes our company has used to push some of these calculations back to our data models - instead of creating them on the application level. As a result, I came across a few posts suggesting using the Domo Governance Datasets, which on first inspection…
-
Make Description Text Boxes Text Areas
As a user who enters many field descriptions (on Date ⇒ DataSet ⇒ DATA tab ⇒ Schema view) or who enters descriptions for DataSet/DataViews I can have the text boxes be text areas So I can see more than a few words that I'm typing It's currently easier to write descriptions in notepad and then paste them in since the text…