-
Governance datasets with Dataset source name
Hi , we are using the azure gen2 data connector, is there a governance dataset that contains directory name and Select File name . so we are not duplicating the same dataset twice. i have looked in the Gov Datasets and i cant find any field that relates to the settings section.
-
Google sheets alternative? Migration Strategy
We have been on a google based email platform since getting DOMO, we have utilized the google sheets connector to connect and import several datasets for ETLs and cards. We will be migrating away from google based email and will have Microsoft office 365 moving forward. Admittedly, I don't have much of exposure to anything…
-
Historic Gas Price Datasets
I'm looking for a dataset that has historical gas price averages at a state or county level. I was able to pull in National level data but I'm looking for more granularity to create something similar to Gas Buddy or AAA's heat maps.
-
Overwriting an Existing DataSet with Workbench
In our team, we have a couple of engineers developing in Workbench on different PCs. When I exported a job from one Workbench, imported it to another Workbench on a different PC and ran it, another DataSet with the same name was created. Is there anything I can do to overwrite and update the existing DataSet?
-
Data Warehouse Summary Values
Can someone tell me what is counted as 'DOMO MAGIC DATA' in the summary metrics shown in the top right of the data warehouse screen? I've read the documentation on the Data Warehouse page and watched the little video but it doesn't specify what that is counting. I originally thought it was dataflows so I created a test…
-
Deleting a batch
I have 2 batches in a dataset that need to be deleted. The batches are easy to identify and the 2 just need to be wiped out entirely. I am wondering if it is possible to just go in a delete a batch, and what would be the best way to do this?
-
Configuration Options for Dataset Copy Dataset Connector
I need to copy a dataset from one instance to another. On the first run, I need to copy the entire dataset. Subsequently, only the new/delta data in the source needs to get appended to the dataset in the other instance. I would like to avoid loading a complete refresh to the destination dataset every time new data is added…
-
Calculate Total Rows of all datasets in an instance
Hi, What DomoStats datasets should I use to figure out total rows of all datasets in a Domo instance? I downloaded DomoStats DataSets and DataFlows App from App Store. But I couldn't find any datasets that contain fields related to row info. Thank you!
-
Formula failing to convert value from a type string to a type date
I think I need some help with the order of operations on this. I have recursive dataflow for Yelp data. I am trying to create a 'metric date' column by 1st, Splitting the ' FILE_NAME' column date example 'security_public_storage_account_time_range_report_11_1_2021_to_11_30_2021.xls Then in the next Tile I am using the Add…
-
Help on recursive dataflow
I have a recursive dataflow that keeps getting hung up from an issue on the join between the recursiveprod and the main data that is being groupby. The error it is showing is DUPLICATE COLUMN NAMES. So I go and change the column name and i am able to get it to run. it then takes that new unique column name and adds back in…
-
Importing Data into Domo from our Connectors
A lot of our data sources are becoming fairly large over a few million rows, and we have noticed refresh speeds getting much slower. I think the solution is to have data appended as of last import rather than replace the whole thing? But I'm curious to know if anyone else has a better solution?
-
Possible To Update All Cards On A Dash At Once?
Hi - seeking recommendations on a faster/better way to update datasets and dimensions for all cards on a dashboard. Currently clicking through each card (80+ on one dash) to update to a new dataset, and also to remove a filter. Going to add a dash-level filter once all the card-level filters are removed, but wondering if…
-
How to reactivate a dataflow disabled from inactivity?
I have a fairly comprehensive dataflow. Most of the datasets that are a part of this dataflow update nightly, but there are some others that only get updated monthly due to limitations in how we get the data then how it gets in to Domo. We use the email connector and when we receive the statement once a month email it via…
-
Domo Date dataset
It's been a couple since I've been in Domo. But when I had it a couple of years ago I distinctly recall Domo having a dataset that had all the dates in it up to like 2030. This way if I had a dataset that I wanted to join by Date I could leverage this dataset to fill in any gaps that my other datasets could have. Does…
-
Workbench | Multiple Accounts in One DOMO Instance
Hi, Is it possible to create multiple accounts to use in Workbench in one instance? This is because we have different permission/rights based on our roles. For example, scenario: We are using one server to upload on premise data - for security and refresh schedule. User 1 has workbench rights and can upload sales data.…
-
Dataset upload by sending email attached excel file
Hello, I heard that it is possible to set that if I send email attached the excel data and it can be uploaded the Dataset in Domo instance owned by the dataset owner. It seems that the Dataset is automatically uploaded by only sending excel file by email. Could you let me know how to do it? Do I need apps etc? Thank you.
-
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?