-
Is there a way to copy/paste a column of Excel Data into a Domo Webform?
I have a Domo Webform that I used to create a bulk filter.....I was able to copy/paste a large column of Excel Data into the Form, add a second column classifying all items as "TRUE", then run the Webform through my dataflows so that I could apply a Quick Filter where I could just Check the "TRUE" box, and, voila.....I had…
-
Has PDP been disabled?
The documentation still references PDP, but I've now created datasets in 2 different ways (API upload and Excel upload), neither has given me the tab to configure PDP on the dataset.
-
Domo Dataset Export into Excel
Hi guys, Although we are integrating more to Domo, there still are some analysis limitations that Domo has. What I'm trying to do is to figure a way to use DOMO as a data source that can be quickly refreshed in Excel. An API feed or plug in or something, that would allow me to use a Domo dataset as an input in Excel or…
-
Combine DataSets to a Filtered Count/Aggregated DataSet with different colums
TLDR: This is a complicated dataset (for me) that I am trying to build. Basically, I am taking data from two datasets, with different columns, aggregating them to columns that is listed correctly in rows... If that makes sense. I need help going about it the right way. Enviroment: Below is sample data I have and what I am…
-
Zohodesk Integration
We use Zohodesk as Customer Support System. In order to track the agent performance and customer tickets in Domo we would like to know wether there's a way to get the Data directly form Zohodesk as currently we've just seen a Zoho CRM connector.
-
Redshift Date & Time to Date Syntax
Hi, I have a column in my redshift table that is stored as date and time ie 6/3/2016 9:23:42 PM When creating the database, I would like to store only the date. What is the syntax for doing this?
-
NetSuite Open Air
Has anyone utilized the NetSuite Open Air connector? My credentials work in a norlam instance of OA, but trying to connect via DOMO results in the following: Failed to authenticate. Verify the credentials and try again. Domo is ready, but the credentials you entered are invalid. Verify your account credentials and try…
-
Scheduling an update of CSV file
Is it possible to schedule an automatic update of a CSV or Excel file? I can connect to my file and update it manually, but is it also possible to schedule an automated update? How can if find out how to do this, if possible?
-
Google BigQuery Daily Imports Help
Hey, So in BigQuery I've got a table full of data for each day: app_events_20180201 app_events_20180202 etc. etc. what I'm trying to do is create a query in the connector that will simply run and append yesterdays data. I've been playing around with things like select user_id from app_events_DATE_FORMAT(current_date - 1,…
-
Google page speed API verification always fails
I've been trying to add the Google PageSpeed Insights connector, but every time I add my API key for PageSpeed Insights it says it is not valid. I've copied and pasted the API key EXACTLY as it appears in my Google Console, but every time I get the message: "Failed to authenticate. Verify the credentials and try again.…
-
Twitter Ads API returns null
Hi Everybody, Recent Organic Tweets Statistics report in Twitter Ads API doesn't work from January 31, 2018. It is always returning with this error message: "Domo is ready, but an error occurred: null". Is anybody have an idea what about that? Thank you, Alex
-
Excel File Connector - How to update
Hello, The excel file connector, which allows us to quickly load an excel file to a Domo Dataset, is quick and easy. My question is, if you add a row of data to the Excel file how do you quickly update your dataset with that new row of data? There doesn't appear to be the option to "Run Now" which you see in the wrench…
-
Data update schedules + Append method
Can anyone help on the two point five issues I'm having: * I have a connector that was set to run hourly. It runs at 5 minutes past the hour which coincides with a lot of other internal processes and is causing errors in our data based systems....so I need to move the scheduled update to a quieter part of the hour (say 40…
-
Editing DataSet settings broken?
Over the past few days I've noticed that it's no longer reiably possibe to edit settings for many DataSets. For example, when you set up an Excel import, you can configure the range of rows to import, etc. The source spreadsheet name, range options, schedule, etc. are no longer visible or editable. Having PDP enabled or…
-
Using Salesforce connector to pull salesforce reports
I'm not sure if this is the correct place to post this but, here it is anyways. Only one of the reports I've build in salesforce is appearing in report dropdown menu, "End Date: Products". I have been unable to figure out how to make reports visible to the connector. I've tried moving the report I want visible to the same…
-
Employee XREF
There is an enterprise datasource that brings in a number of productivity metrics by employee code. At a building level, I have a cross-reference file that can match up the employee code with their cost center and operations manager in my building. I am unable to modify the enterprise datasource, but need to create a card…
-
About this "Dataset Data Connector"
So there's this Dataset Data Connector. This allows a dataset in one Domo instance to be shared into another Domo instance. I think this might work for our use, but does anyone know if I can specify what columns in a shared dataset can be shared via the Dataset Data Connector? And, while I'm at it, has anyone actually used…
-
REST/URL API Query - where to enter?
Hi, I have a JSON API query for our database which is working in Klipfolio and in Postman but I can't work out where to enter the address, headers and body to create a new Domo datasource. I've had a look at workbench and at developer.domo.com and keep getting stuck. I assume this must be a fairly simple thing to do…
-
filter in custom connector google analytics
Hi There, Am trying to create a google analytics connector dataset by applying multiple dimension filter with 'and' condition for the dimensions however am getting 'invalid dimension format error'. Hence could you please review the syntax and let me know whats incorrect here. * The filter should contain ‘and’ clause –…
-
Granting another user permissions to view a data set
Is building card based on a data set and sharing it the only way to grant a user permissions to build her own card based on that data set or is there some other way? P.D.P. does not seem to do the trick, or am I missing something?
-
How do you automatically pull stock data into Domo?
Has anyone connected to Yahoo Finance or ETrade? I want to pull stock data.
-
New Google Analytics Enterprise connector
Hi, Yesterday we found out that Google Analytics Advanced is not available any more. It has been replaced by a Google Analytics Enterprise version. This means, for us at least, that all our current Dataset are still running, but any new one can only be created with the new GA Enterprise version. It's an absolute NIGHTMARE!…
-
Unable to reload/execute a DataSet from within Domo
New to Domo, enjoying it so far! I've got several DataSets coming into Domo either via Postgres pulls or via Excel pushes from Workbench. Today I added a new DataSet via Workbench and went into the Data Center to check it out. I noticed that over in Domo, a stack of my existing DataSets were marked as stale with a warning…
-
Can I See Email Performance from Pardot in Domo?
I've connected Pardot to Domo for the purpose of seeing email performance (open rates, click rates by email send, etc). However, I can't see how to do this. Is it possible to use Pardot for email tracking?
-
How do I lookup data from another data source? e.g. Validate US State abbreviation
New to Domo, but masterful with Excel/VBscript/Formulas - scenario, I have uploaded a spreadsheet with rows of data that have a 2 character STATE code column. 1. Source "A" -- The States can consist of US States or Canadian regions. 2. Source "B" -- I have added a separate data source spreadsheet to list/maintain US State…
-
Email Connector - multiple attachments
I'm trying to get an email connector to work on an email that contains multiple attachments. It seems that even though I specify the name of the attachment in the details of the connector, it always seems to pull in the data from the first attachment.
-
Is it possible to snap shot salesforce data on a daily basis to run point in time reports?
Can Domo capture daily Salesforce snap shot data into the repostory to be used in reports, like opportunities, that can compare two specific dates? For example, we want to compare all the Oppty stages same time last week to see what changed.
-
Copying the current state of a dataset into an independent snapshot
Is there an easy way (beyond exporting and reimporting a dataset as CSV, which can lead to export/import errors) to capture the current state of a dataset and copy it into a new, independent dataset? Say I'm looking at a dataset that updates daily using a complicated connector, I don't want to copy the actual connector…
-
Possible to build a "roll up card?"
I need a "card" that will display certain metrics calculated by our existing cards. The Domo Design Studio came very close to what I need, but the "card" needs to be downloaded to a static document. Therefore, all of the tooltip information is lost and there is no way (I beleive) to show the actual value of the buckets in…
-
Excel and PowerPoint plugin
The Domo Excel plugin does not give any field to input the server name. I installed it on Excel 2013 64bit. Is there any work around for this?