-
How to Determine When Returned Orders Have Been Fulfilled
I'm struggling with how to handle this problem conceptually. My company delivers our products to customers and in the delivery tables, there's a field for Units Ordered, Units Delivered, Units Accepted, and Units Returned. This table is aggregated by month so the dates are always for the first of the month for the customer…
-
Marketo Connector API Data
Hi All, I have connected the Marketo Dashboard, but I'm unable to validate the data against the Email Performance Report in Marketo. On their community page I found a post that says: Marketo Support says DOMO is taking raw data logs from API connection while Marketo's algorithm is doing the following: * Reporting unique…
-
How to do generate_series in a SQL dataflow
Hi, I'm trying to elimate the need for a database between our production system and Domo by doing all ETL work within Domo (I know this may take longer to process). The database is PostgreSQL and some of the queries that I need to do in Domo use a function called generate_series, but it appears there is not a simple MySQL…
-
Hour-over-Hour for the past 24 hours
Hi, I have been trying to figure out how to graph performance of applications for each hour in a rolling 24-hour period (and once I get that then I need to do it hourly for a rolling 30 days). My database behind the scenes is a MySQL database where I added a calculated column so that I would have just the date and the hour…
-
Unable to Convert to a Date and Time Format
Hi, I am importing data from a txt file. I have several columns that are timestamps. For example, the data is 20160421114552 - meaning 2016/04/21 11:45:52. When I try to convert this to a date and time in Magic ETL, I select the column, put the new data type as "Date and Time", and select the format with "Year First". Yet…
-
Altering how a card/chart is displayed in a Group/Collection
Hi. I'm new to Domo and I was wondering, is any way to alter the graph that is displayed on the card when I view the group/collection? For instance, the attached graph is so scrunched and tiny that you can't get any value at a glance for a dashboard type of experience. So I was hoping that I could alter the "thumbnail" in…
-
Marketo Connector and Data Validation
Hi All, I have been trying to use the Marketo Dashboard and have it populating. However, I cannot see to properly validate the data compared to the Marketo reports. I've been researching and I found something on the Marketo Community where a user posted: Marketo Support said DOMO is taking raw data logs from API connection…