-
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?
-
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.