-
Does anyone prefer Box.com vs. Dropbox for automated import of flat files from an email attachment?
I am looking to find the best solution for automating the import of flat files off attachements of specific e-mails. Are one of these solutions easier than the other? I am wondering the specifics on how it would only grab a specific, desired e-mail. These files will most likely be appended bi-weekly to a dataset in DOMO.
-
Fitbit Connector - User Activities Steps - Friend ID's
I'm trying to pull in steps for a Fitbit user and a series of the users friends. I have it setup where I can pull the steps for the user using the User Activities Steps report. When I try to enter the ID of one of the users friends however, the connector fails. I got the friend ID by going to the friends profile page and…
-
Has anyone successfully connected into JW Player
I have a customer moving from BrightCove (which we have an API for) to JW Player. Have we connected successfully into JW Player and what does that connection look like? Status of a possible JW Player API?
-
Can i convert columns to rows?
I have a data source that has data in columns based on dates or Yearmonth formats. I need to pull some of that data out and convert it to a row. For Example: Column 1 Column 2 201510 500 201511 600 201512 700 201601 300 201602 900 I need to create a table: 201510 201511 201512 201601 Row 1 500 600 700 300 Can I do this…
-
Anyone using custom dashboards in Google Analytics?
I have custom dashboards built in Google Analytics that I want to pull into DOMO, but their connector only grabs the home stuff that doesn't do anything for reporting at all. Is there a way to point the connector at custom dashboards for reporting in DOMO?
-
Anyone using the Basecamp connector?
My company uses Basecamp to discuss projects and assign tasks, and I have connected the data to Domo to help project managers visualize workflow. I am wondering if anyone else is using the Basecamp connector, and if so how? On a side note, a Basecamp 3 connector would be nice.
-
Is a workday connector in the pipeline?
Is there a workday connector in the pipeline? Should we expect to see this soon?
-
Responsys API
Hello - Does Domo have an API with Oracle's Responsys?
-
Converting String to Date in Dataflow
Hi, I have a dataflow where I combine two data sources. source1 has a date field formatted MM/DD/YYYY, and source2 has a date field formatted YYYY-MM-DD - let's call them date1 and date2. source1 also has far more records than source2, so I'm trying to perform as many calculations as possible on source2 rather than…
-
weekly sales dataflow
Can i create a dataflow that creates a column in the dataset that sums my daily level sales to weekly level sales? My input dataset has sales at the daily level, and i would like to join it to another dataset that only has sales at the weekly level, so I'd like to create a column that has the weekly level sales with the…
-
Select distinct value from table using Magic ETL
e.g. Selecting distinct date from date column using Magic ETL?
-
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!
-
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 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,…