-
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…
-
Would you like a tool that unlocked more power than Beast Mode?
Have you ever wanted to do more in Domo as a technical person and wanted a tool that unlocked more power than Beast Mode? See our tool called “magic”. Click Here to Learn More
-
Difference Between 2 Google Analytics connectors
My cusotmers try to use GA connector. Now 2 Google Analytics connectors are available on Domo. I can not identify differences between 2 connectors. I would appreciate if give a guidance which one I should use. Regards, Shin
-
How can I get access to the DataFlow functionality
Please contact Domo Support (support@domo.com) to get enrolled in our DataFlow certification course. It is a self-taught course that ensures individuals have a basic understanding of MySQL. Thanks
-
How do I apply regex filters in the Google Analytics connector?
-
How to add multiple commands in one Transform inside a dataflow?
How do I make so I can insert multiple commands in one Transform box. For example, I am adding multiple indexes and don't want to have to create them in multiple transforms. create index SO1 on tech_salesorders(Sales_Order_ID) create index SO2 on tech_salesorders(Customer_Organization_ID) create index SOL1 on…
-
What does the "Use Raw Numbers" setting for email connectors do?
Recently, we ran into an issue with one of our email connector datasets where a "Currency" column was being formatted as a string which was causing issues down the line in other dataflows. We're not sure how the problem initially started, but we found that enabling the "Use Raw Numbers" setting seemed to fix it and…
-
Google Analytics Connector - Page Views with no Sessions - how come?
Hi, we've been using the GA connector for a while now with no issues but have noticed on a specific day that there are page views with no related sessions. How is this possible? Is there potentially something we have setup incorrectly in the Domo to GA connector.
-
Adobe Analytics and Domo Connection
Hi everyone, DOMO Database: we created a Dataset and were able to pull up a basic report. However, while trying to add some of the required dimensions and metrics into the dataset, we are receiving the following error, the screenshot of which is also attached. We have Admin Access to both Adobe Analytics and DOMO. “Domo is…
-
Domo connector supporting OAuth for Coupa is now available.
Beginning Jan 2023, Coupa will no longer support API keys for integrations and will require the use of OAuth instead. This means that customers using Domo’s Coupa connector at https:/<instance_name>.domo.com/appstore/connectors/com.domo.connector.coupa will need to recreate their datasets using the Coupa OAuth connector,…
-
JSON No Code - Parse Issue
I'm connecting to Parallax API, but am running into Parsing issues. When I go to the parse section of the JSON Connector, I am able to fully parse out the data into the necessary format that I need, but when I run the connector there is a column that won't parse. In the preview the data looks like this: Pre-parse:…
-
Responsys Connector
Is anyone else having an issue with the Responsys connector returning the schema for the data sets but not the data sets themselves? This seems to be a bug with the connector.
-
Pull Data from AWS Bucket which is encrypted.
Hi everyone, I need to pull the data from AWS bucket which is encrypted. Is there a way around to pull the data using Amazon Advanced S3 connector. Thanks,
-
Pull files from Amazon Bucket
Hi everyone, Amazon bucket is password protected, is it possible to pull the files in Domo using Amazon s3 advanced connector? Thanks
-
Reach Data (LinkedIn Ads)
Hi All, I recently Swap approximateUniqueImpression column with averageDailyReachMetrics_approximateReach in my dataflow diagram. Even though the dataflow is running completely fine without error, it's the LinkedIn API is causing an error and making dataset update unsuccessful. Error: Domo is ready, but LinkedIn Ads…
-
VARCHAR Length
I am running into this error message for SQL Writeback Connector. Domo is ready but Sql Server returned: Received an invalid column length from the bcp client for colid 1. Is this because the datatype is varchar(255) in SQL server, but DOMO has varchar(max)?
-
Automatically push data from DOMO to Excel (.xlsx)
What's the best way to automatically push the data from DOMO to Excel (.xlsx)? FYI: I tried writeback connector (only work for .csv) and Excel plug-in (Can't automate it). Thank you in advance for any help.
-
SharePoint Writeback
Is there a way to automatically save Excel to .xlsx instead of .csv?
-
HOw can i connect to azure managed instance
Hi I'm trying to connect to an Azure Managed instance but no matter If I use Azure SQL server or azure synapse SQL. It's unable to connect. I have even whitelisted all ips mentioned on DOMO Knowledge base. Please suggest.
-
Google Advanced Analytics Connector Error
I am getting this error when I tried to connect with the advanced connector. Any idea what it would be ?
-
UTM_ID in Google Analytics Advanced connector
Anyone have experience pulling in the UTM_ID into the GA4 connector? We are implementing a UTM_ID as a unique ID for each of our UTM Campaigns and would like to pull this through. Would this show up as a custom dimension - or would it show up in the traffic sources when it is received?
-
Airtable Connector
I'm having some issues getting all the fields from Airtable to come into Domo. It almost looks like the first row where the field is blank is not coming into Domo, anyone experience this and if so, how to get the fields to come into Domo?