-
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?
-
JIRA Cloud Failing for Last 7 Days
Not sure what's going on, my JIRA dataset has been failing for the last 7 days with the following error: Domo is ready, but Jira failed to return the requested data. Please try again later. It's not that many rows (~10k) See screenshot for the history When it first started failing (Aug 19) it was due to a JIRA password…
-
Salesforce amount field importing as text
Hi, when importing (direct from the server via the connector) data from SFDC, the amount field is coming through as text, now it does have the currency denomination in it (EUR, USD etc.) and commas/periods but even when taking these out via a replace in the ETL it still will not convert the field to a numeric field. any…
-
In MySQL utilizing the Transform property, my where clause is not delivering the expected results.
In MySQL utilizing the Transform property, my where clause is not delivering the expected results. I cannot limit the data I am pulling in thus using the transform property to only look at the date from 01-2016. Here is a snippet of the code: SELECT DATE_FORMAT(p.`date`,'%m-%Y') AS Date, p.`Campaign`, p.`Cost`, CASE WHEN…
-
Office 365
Will an Office 365 connector be coming soon? Our agency is in the process of converting to Office 365. It would be fantastic if we could directly connect to our files that will soon be moving into the cloud, similar to how you can connect to Google Sheets.
-
Using MYSQL transform how would I convert a date field mm/dd/yyyy to mm/yyyy?
Using MYSQL transform how would I convert/create a date field changing mm/dd/yyyy to mm/yyyy?
-
30 day running date alert
Hello, I'm trying to create a date range that will be continual, comparing today to 30 days ago. I have a feeling it's somewhere within creating a calculated field, but I don't know what the formula would be. My idea would be to have a specfic filter that would include date(today, today - 30days) but the actual process is…
-
SQL Dataset Inconsistent Date Recognition
I'm using tsql to create a dataset in Workbench via ODBC connection. I noticed that DOMO does not recognize 2 of the 3 date columns as dates. It thinks they are text fields. I have formatted them all the same in my sql statement and cannot figure out why it would recognize one but not the other. CONVERT(char(10),…
-
How do I get Domo to automatically pull in Excel data?
I have data in several Excel spreadsheets, which are updated every day. How do I get Domo to automatically pull in this data? At the moment I can only see how to manually update (with the option to be prompted every day to update). Given there are several sheets, all of which feed into dataflows which run first thing in…
-
Time Zones?
Is there a timezone setting for our data sources? Or what is the timezone to set for our data sources? Trying to figure out if I need to change timezones on our MySQL data source
-
Sum a case statement in SQL data source
trying to group and sum up a case statement, but keeps erroring out (Failed to retrieve data. Error ticket#.....). tried moving the parentheses around, but nothing's working. below is my query, any ideas? SELECT A. TRANDATE, A. TRANID, A. TRANSACTION_TYPE, SUM (CASE WHEN A. TRANSACTION_TYPE = 'Sales Order' AND B.…
-
how do i connect my mysql db using ssh tunnel?
how do i connect my mysql db using ssh tunnel? My mysql db is hosted on AWS - but it sits in a private network and can be accessed through my EC2 server that sits in a public network. The way we access it today through Mysql is through SSH connection. And when we use tableau - we use SSH tunnel. We would like to move to…
-
Google Analytics Advanced connector - can't get desktop device metrics
I'm trying to create a simple pie chart to show the split of sessions by desktop/mobile/tablet. In GA the dimension is "device category", but when I bring this dimension into Domo it only has mobile and tablet. The figures for mobile and tablet match what I see in GA so I'm on the right track, but no desktop metrics. The…
-
How do I avoid decimals from being truncated while bringing data from Excel?
I have an Excel that has several measures that are percentages. The Excel is in a Box folder, so I am using the Box connector to bring the data to a Domo dataset. Everything works fine, except that the percentages get converted to decimal numbers (so, all are <1) and truncated to 2 decimals... so that is causing me issues…
-
Using unpivot in mysql with many columns
My Input looks like this: I want to see my output like : (I am trying to do unpivot in mysql data transform in Domo) Product Type , Date, Revenue A , 12-31-2015, 100 B,12-31-2015, 0 I am trying to use stored procedure: create PROCEDURE unpivot_cols() BEGIN SET @sql = NULL; SELECT GROUP_CONCAT(DISTINCT CONCAT('select…
-
Dynamics CRM Connector
I can see Dynamics CRM on the connectors list (https://www.domo.com/connectors) but it's not available to select as a connector when i am logged in (https://www.mycompany.domo.com/connectors). I can get to the sharepoint one, does anyone know the public url for the Dynamics CRM connector?
-
File listing the current input and output datasets and their corresponding dataflows
Hi Dojo community! Do you know if it is possible to extract from Domo a list of input and output datasets and the dataflows that create or input them up to date. We are trying to do a quarterly cleanup of our instance and having this type of information would be really helpful. Another useful feature would be to be able…
-
DOMO importing columns from Google Sheets that don't exist.
I'm importing some data from google sheets. I occasionally edit the columns in the sheet. When I re-import the data in DOMO, it keeps importing the now deleted columns. The deleted columns also continue to show as a selection when making a card. Any Idea how to fix this? The only success I've had was to delete the data…
-
Importing Google Analytics Custom Dimensions
Wondering if there's a way to import Custom Dimensions created in GA. This used to be a feature in the beta version of the GA connector, but now all you can access are the static / predefined metrics and dimensions. Anybody know what's up?
-
dynamics crm connector
Is there a prebuilt connector for dynamics?
-
Data Not Pulling
I have a Salesforce Connector that has worked perfectly for months. I noticed today, that all of my connectors were running extremely slow when updating...and then when I ran this particular connector (after turning off all auto updates on all connectors), I received the errors shown in the screenshot (as well as one that…
-
Historical Facebook data
In Facebook Quickstart, am trying to edit a card for Fan Growth in 2016 data but you cannot edit the date range beyond "All-time" (which is the date you signed up). It just says "no data exists". Any help / ideas?
-
How do you get Google Adwords data into Domo to use with the Google Adwords Keywords Performance App
I want to test out the Google Adwords Keywords Performance App, but I can't figure out how to pull in the Google Adwords data that Domo outlines here: https://developer.domo.com/docs/installation-guides/google-adwords-keywords-performance I don't see any connector for it, and I don't see it in my Google Analytics…