Dataset

Reconnecting Disconnected Output DataSets and Cards
We are developing under several accounts (e.g. Dev1 and Dev2). In order to organize the ownership, I have changed the ownership of some pages and cards to one account (Dev2 > Dev1). Then the connection between the DataSet and the card got disconnected and the card is no longer visible. For the card with a direct connection…
Updating a DataSet Triggered by the Finish of a Glue Job
We are using a Connector to retrieve data from Amazon Redshift and display it in Domo. We use AWS Glue to retrieve data from Oracle and store it in Redshift, but I don't think it's possible to trigger the end of the Glue job to update the DataSet in Domo. Currently we schedule the DataSet update around the time the Glue…
Handling multiple aggregation levels from source data
My company uses syndicated POS data from sources like IRI, NPD, and retailer POS. There are many measures that cannot be aggregated from the item level data, so I need to bring in pre-aggregated data in addition to the non-aggregated data. I was planning to have one column that indicated the aggregation level, but when I…
Why is my 3rd PDP breaking the dataset for users?
Edit: Turns out I'm incompetent and spelled John Doe's real name wrong. Where's the face palm emoji? Hi all, I added a third PDP policy to a dataset, and now it's showing blanks for people who fall under 2 of them, but I'm not 100% sure why. My PDP policies are based on trusted attributes. Essentially, if the person…
Line breaks and special characters are being added to a webform
We use a webform for our Sales roster. We have had an intermittent issue with line breaks and special characters being added to the rep's names which causes quite a few issues. The very first sales rep on the roster is getting a line break added to her name. There's another sales rep getting multiple line breaks and…
Remotely trigger a DataSet refresh?
I'm checking out some of our options for speeding up data ingestion in Domo. A few of our Postgres pulls are taking longer than we would like, and I'm exploring creating a materialized view to cut the PG processing time down to 0, from Domo's perspective. That still leaves the data transfer time, and the Domo processing…
Should I really be using UPSERT KEY just to APPEND data?
I have a huge dataset I've uploaded through Workbench. I now want to run a daily APPEND of new data only. I don't see a way to define an "APPEND" key, just an "UPSERT" key. My data won't really change, so I really only need inserts of any records where the defined ID is not already in Domo. My append query looks for a…
In Workbench what does "DataSet Type" change?
I have Workbench jobs uploading Microsoft SQL Server tables to Domo. For "DataSet Type", I accepted the default of "Workbench ODBC". After setting up my jobs, I noticed there is a "Microsoft SQL Server" dataset type. What's the difference? In Domo, the icon changes if I upload as a "Microsoft SQL Server" dataset type. If I…
Notification of DataFlow and DataSet Processing Failures
I'd like Domo to notify our admin team's Google Chat or mailing list when a DataFlow and DataSet fails to process. I know that it can be configured in "Notifications" from the top right corner of each DataSet, but I don't think it is possible to notify any email address other than the owner. I have also not found a webhook…
Dataset Switching using vb.net
Does any one have experience with dataset switching using vb.Net to switch datasets on the fly? We are having issues getting the json string generated. Any help would be greatly appreciated!
Need Similar Column names for different connectors
Hello, I have two different connectors and I am trying to eliminate creating a seperate flow by having a similar column between different connectors. Eg: Dataflow_details has dataflow_id and dataset_details has dataset_id. However, none of them have the same column in each. Is there way to join the connectors or do so on…
"Unable to load the Data Source" - DataSet via Email
Hi, I'm hoping someone can help with a problem that I can't find any information about anywhere. I have two DataSet via Email connectors that receive similar data in the form of "Email Body as HTML". Both were working, and had received a few hundred emails over a couple of weeks. I am now getting an "Unable to load the…
DataSet Views - Outer Join
Hi all, Relatively new to Domo and really enjoying the experience so far :) I've been taking full advantage of DataSet Views and love how easy this facility is to use. One suggestion though. The online information states that "we support Left, Right, and Inner Joins". Why not outer joins though so that the option to retain…
Can you remove duplicated rows of data in a data set?
We have a data set that is updated from a Google Sheet. I see that back in June we have duplicate entries for June 22 and June 23 in the data set, yet the data in the Google Sheet is not duplicated. Is there a way to edit the data that is in the data set to remove these duplicates?
Edit Calculated Columns in Saved Data Views
Once a calculated column is added and the data view is saved, it would be helpful to be able to go back into the view and make edits to the calculated column if needed. Currently a new column must be created and a new dataset view saved.
DataSet Copy
Does anyone know how the DataSet Copy Unload connector works?
YOY & Net diff Beatmode calc
I have kind of a unique YOY period that I am trying to create a report around. I am taking counts of leads that come through different marketing 'Marketing Sources', and only looking at the past 15 day window for each. This is straight forward. Take the counts for each source in the `Marketing Source` columns and use the…
Dataflow creation best practice and recommendation
A lot of the dataflow creation I do is taking 2 datasets that differ slightly and don't have an easy 1:1 comparison that makes joining the data very easy. usually I am using 1 report for almost the entire visualization, and puling a column or two form the 2nd report. Since the reports aren't in an identical format, and…
Dataset beast mode calculations
Is it possible to copy over beast mode calculations from one dataset to another? I have one dataset which is using most of the same fields from other dataset. I wanted to copy all beast mode calculations.
Google Ads
Hi Team, Does anyone know which connector I should use for google ads? Thanks, Yuvraj Chavan
Google Analytics Advanced Connector - dataset showing multiple rows per Month
I have datasets with Month of Year selected as dimension from Google Analytics Advanced Connector and I noticed that some of my datasets are producing multiple rows per month while some do not. When summing up the values, they do add up to the total except for averaged columns (i.e. Avg. Page Load Time, Avg. Session…
Google Analytics Advanced Connector - User count does not match with GA
I'm using the Google Analytics Advanced Connector and I can't seem to get the correct/exact count of Users when comparing to Google Analytics/Data Studio numbers. I'm aware that Google Analytics aggregates the Users differently compared to the Sessions/Pageviews depending on my selected dimensions (i.e. in order for me to…
Alerts not sharing in Buzz channel for specific datasets
I have alerts set up and shared with a Buzz channel on several cards but the alerts only post to the channel for specific datasets. I still receive the notifications regularly otherwise. Does anyone know why this is happening? The data and card permissions are all the same.
Data Stuck in "Storing" Mode
Hi All, Domo went down for a second earlier today when it came back up it appears that some of our datasets are stuck in storing mode. I was wondering if anybody had any experience troubleshooting this issue.
Adobe Analytics OAuth 1.4 connector - Update a dataset hourly
Email connector not finding link
Hi there! According to the KB article for the Email Connector this should be working correctly, but here I am :) I receive a nightly scheduled XLSX report from a third party reporting tool. They recently stopped attaching the report to the email and instead put it a link to a page which then downloads the file from AWS.…
Datacenter Autotags: Manual vs Scheduled, Append vs Replace
I have been trying to have the discipline to tag my datasets as I set them up or adjust them, based on these important major categorizations: Scheduling: MANUAL vs SCHEDULED Update Type: APPEND vs REPLACE It would be excellent if Domo could auto-apply the appropriate tag based on those attributes, upon creation/update of a…
How can I compare YOY data with an offset of a couple of days?
Hello, I'm 100% new to DOMO and I'm looking for some assistance. I'm trying to compare data from 2021 against data from 2020 using DOMO with a dataset connected combining data from multiple Adobe Analytics sources, and other accounts. Specifically I need to compare promotional revenue data for a Memorial Day promotion. I…
How to add index number in the dataset
Hi Team, I have a dataset with around 1000 records. now I want to add one field in it name "id". it would be starting from 1 and end with 1000. I don't have an idea how to add it. Please suggest a better way. Thanks in advance :)
Workbench Job Hanging, Dataset stuck on 'Preparing'
I have a scheduled Workbench job to update a dataset that typically takes 30ish mins to run. The job started yesterday at 1:37pm and has been stuck on 'Preparing..' in the Result field (on the History tab) since then. I just canceled the workbench job and started a new manual run. It started a new run, but the history tab…

Upcoming Events

Connections Tour
Spend a half day with your peers, Domo enterprise customer speakers, and product leads to explore real-world use cases and new platform innovations. Whether you’re a power user or just starting to learn about Domo, don’t miss this opportunity to learn from like-minded professionals about how they use data to multiply their…
SYDNEY: Domo Power Up: Unlock Domo, Unlock Growth
Time: 1:00 PM – 5:00 PM AEDT Location: QT Sydney, 49 Market Street, Sydney NSW 2000 Event Space: Screening Room Agenda: Dress code: Business Casual Am I required to bring anything? Just yourself! Laptops are optional but helpful if you need assistance with your Domo instance during the breakout sessions. Public Transport…
Connections
Spend a half day with your peers, Domo enterprise customer speakers, and product leads to explore real-world use cases and new platform innovations. Whether you’re a power user or just starting to learn about Domo, don’t miss this opportunity to learn from like-minded professionals about how they use data to multiply their…
Connections tour
Spend a half day with your peers, Domo enterprise customer speakers, and product leads to explore real-world use cases and new platform innovations. Whether you’re a power user or just starting to learn about Domo, don’t miss this opportunity to learn from like-minded professionals about how they use data to multiply their…
MELBOURNE: Domo Power Up: Unlock Domo, Unlock Growth
Time: 1:00 PM - 5:00 PM AEDT Location: ACMI, Federation Square, Flinders Street, Melbourne VIC 3000 Event Space: Swinburne Studio Agenda: Dress code: Business Casual Am I required to bring anything? Just yourself! Laptops are optional but helpful if you need assistance with your Domo instance during the breakout sessions.…

Dataset

Discussion List