-
Adding new element to dataset. Will it interrupt related dataflows?
I’d like to filter according to a new specific element I'm adding to a dataset. Will it interrupt dataflows associated with that dataset?
-
Is it possible to connect a locally hosted MySQL database to Domo?
I'm using MAMP and was wondering if it was possible to connect it to Domo without exposing the database to the Internet. Thank you!
-
Salesforce returned a 'INVALID_FIELD' error after the 'Custom Fiscal Year' is enabled in SFDC.
Below is the error I received... >>> Domo is ready, but Salesforce returned a 'INVALID_FIELD' error. Please fix the query and try again. Fiscal,FiscalQuarter,FiscalYear ^ ERROR at Row:1:Column:1026 No such column 'Fiscal' on entity 'Opportunity'.If you are attempting to use a custom field, be sure to append the '__c' after…
-
restricting access to data sets
Hello, I'm new to Domo. Our organization is currently planning to roll it out to the organization in the near future. I've put together several data sets that will be available for people to use in card creation. There are a couple of these data sets that have sensitive data and should not be available to the entire team…
-
Truncation error when calculating a field that is formatted as a percent?
Hi, I am trying to run a few calculations on a field in my .csv (box connected) data set that is in percent format. Currently i'm receiving a truncation error. If I do no calculations and process the data set, the field in my output shows as text. I have tried various CAST and CONVERT functions in my transforms but the…
-
Monitoring dataset size in datacenter?
How can we monitor dataset size in the data center? E.g. if data set size decreases after data upload or dataflow run, can we get an alter, if not, is there any way around to get informed about this kind of scenarios?
-
Can you filter by a date range in the Magic ETL? Example My_Date = last 30 days?
-
Checking a columns datatype
Does anyone know if there is a way to check a column's datatype? I've noticed sometimes if bad data gets uploaded to a datasource it can change the columns type (for example from an int to a string) and I wanted to write a query to catch that faster. Anyone have any ideas?
-
Run of DataFlow Times Out
I've got a dataflow that times out whenever I try to run it. The eror message says "Cache file timed out", and it looks to happen somewhere around 10-12M rows. I'm filtering one of the tables to reduce the number of records to process, but the time-out error occurs before it gets to the filter step. Any suggestions?
-
Best practice for dataset refreshing in DataFlow
Hi, I am wondering if there is a better way than mine with regard to dataset refreshing. Please advise. I am dealing with an aggregated daily order dataset on DOMO which has more than million records in total. Let's call it "order_dataset". The original data source is an external database, so I push data from it via…
-
Join Types Redshift
What are the syntaxes for joins in redshift? Full Outer left right Don't seem to work only the word "join"
-
is there a way to push data to a third-party?
I would like to know if there is a way to push data from DOMO to a third-party tool, like Exact Target. Thanks, Wade
-
How can we change data source behind the cards without loosing the calculations in cards?
I have a situation here, I created domo cards based on my development data source and now I would like to change the cards pointing to Production data source. When I did this for my other project I lost calculations behind all my cards. Is there anyway I can do this without loosing cards? Thanks Srilatha
-
How do I share a dataflow?
I'm an admin, I have someone who is privilged. How do I share the dataflows I have created without making him an admin?
-
Comparing Data Sets
If I have a data set on an inventory of items and a second data set on the sale of those items, how might I compare those data sets with Domo to discover 1) which items in our inventory have never been sold and 2) the average length of time before items added to our inventory are sold? Thanks!
-
Domo on handling tranactional data and dimensional changes type 1 and type 2?
* By using Domo’s built-in data capturing methods.* How does Domo handle transactional data?* How does it handle duplicate data in regards to transactional data? * How does Domo handle dimensional changes (Type1 &Type2)?* Type 1 - old data is overwritten by new data * Type 2 – multiple records are created to track data…
-
Magic ETL/MySQL ETL and Datasets
Is there a way to see what ETL created a dataset? If the ETL tool showes and error at 46,796,637 rows, how are there 85,722,082 rows in the dataset?
-
Has anyone tried to create a custom schedule for an ETL job?
I am trying to create a daily snapshot of our datasets regardless of whether the data change or not. The current ETL process I have created can do such, so long as the dataset in which I am pulling data is update. However if the data is never updated, the ETL is never kicked off, which can create a gap in our day to day…
-
Monitor Dataflow in Card
Is it possible to monitor number of dataflow, failed data flow, sucessfully ran dataflow per day in a card? In short, is there any monitoring tool available for dataflow?
-
SFDC data connector- report
Hi all, I have a quick question on SFDC data connector. I’m trying to pull SFDC Task object data in Domo which includes our TLG call and dial data. However, the task object seems to be too big to be imported. I only selected 5 fields in the object and it took forever to import. I saw another option to import SFDC is…
-
Dynamically importing files.
I have a situation where a data source is coming in via email only, no available data connector in Domo. The file needs to be appended with a snapshot per email. Is there an automated file archive processes that Domo can provided? Basically, i would need to create a connection to pull the data from a file in a folder path,…
-
Is there a way to join data on a date between a start and end date?
This is really a data flow question. I have assignments in one table that have a start and end date. I am trying to join this to daily activity. set one look like code start_date end_date sm 1/1/2015 2/1/2015 asc 2/2/2015 6/2/2015 then there is daily activity and I need to see how much daily activity happened under each…
-
How to Capture Transactional Data Changes in Domo
We are loading sales order and purchase order data via Workbench from our ERP to report on booked orders, open orders, etc. However, our sales orders may be opened for a long period of time and frequently change. For example, the customer may revise their quantities ordered throughout the month prior to shipment. The only…
-
Normalize data in Domo.
I have a data source that looks like this: Type BusinessUnit Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Sale US 4 6 7 2 1 3 4 6 8 2 1 7 I want it to look like this: Type BusinessUnit Month Amount Sale US Jan 4 Sale US Feb 6 Sale US Mar 7 etc etc an I do this once the Data source is in Domo maybe via Data flows if no…
-
Has anyone noticed that the Domo Zendesk Connector not sending over Closed by Merged tickets?
I'm currently in the process of creating reports originally made in Zendesk Gooddata. In our attempts to recreate the report in Domo we have noticed that the tickets tagged "Closed_By_Merge" are not coming over in the data set when using a general query Has anyone else seen this?
-
Existing Data Flows are unavailable to update
2 of my DataFlows are no longer available for Editing. i can edit the name/description, but i can not update the actual DataFlow. this is because the don't appear in the DataFlow section of Data Center. anyone else come across this?
-
I added new View(Profiles) to Google Analytics but they are not in Domo
To make the new Google Analytics View(Profiles) available for the Domo user, you need to grant permission for those View(Profiles) in Google Analytics. Step 1. Sign into Google Analytics and navigate to the main page that shows the View(Profiles. Step 2. Go to the dropdown next to your email address at the top right and…
-
Hierarchical Relationship Between Columns In Data Sources
Some of the sources I work with have columns with a hiearchical relationship. For example, in the following data source, there are two columns named Master Source and Lead Source: The Lead Source (Column C) is always a subset of the Master Source (Column B) . Is there any sort of code that would set up the relationship…
-
Best Practices On Changing Data Sources
Our company has been using Domo for a few months, and when we began, I constructed a large variety of cards from the .csv files that we used for uploads through Workbench. Now our dataflows are shifting over to the databases themselves. Are there any best practices for transferring the cards from data sources dependent on…
-
Search Term and other dimensions in Google Analytics
Hello everybody, I've been working with Google Analytics and Domo for more than a year. I know that Google Analytics connector is still in Beta and I was hoping that it this new conector allow us to select the dimensions and metrics we are looking for. This conector has predefined dimensions and metrics (that can be useful…