-
More info in logs
It would be very useful if, when executing a Domo ETL, a log file was generated to see the details of potential failures in the process. Currently, if there is a failure in any of the Domo's own boxes, you see that the process has been interrupted in a part of the process but we don't see the details. Also, if the process…
-
Update DataFlow Name and Description without Going into a DataFlow
Currently, you must open a DataFlow to the editing page (either MySQL or Magic ETL) in order to update the DataFlow name or description. This is tedious and requires a lot of extra clicks and loading time, especially with MySQL DataFlows. Currently, DataSets allow the editing of their name and description right from the…
-
Different Page Background Colors for DataFLOW page and DataSET pages
Yes, I know I should know when I'm in a DataFLOW page vs. the DataSET page. But I don't. And it's confusing. Change the background page color when I'm on each so visually I don't have to look around to see where I'm at. Doesn't have to be bright crazy colors. Wouldn't that be helpful?
-
Option to Require Descriptions on DataFlow Versions
Domo currently supports adding descriptions to edits/versions of a DataFlow. However, these descriptions are not required and thus are often easily ignored. It would be very nice to have an option to require these descriptions on an instance-wide basis. Descriptions are absolutely critical to understanding how a DataFlow…
-
Card not reflecting updated Dataset/Dataflow updates
I manually run the input dataset that feeds into the datasets of 3 other dataflows. And all 3 dataflows reflect the inclusion of new data, but this is not reflected in the cards' visualization, as in the cards are reflecting data from the previous update despite the dataflows reflecting data from the new update. Any ideas…
-
How is Timezone inherited from source then converted?
I have a dataset coming in from the Gong connector and some timestamps come in as text fields (scheduled, started). Our Domo timezone is set to Eastern. When I cast data type as timestamp, the times move up 3 hours. Should I assume the Gong source data is Pacific (Gong is in SF) and Domo is inheriting the timezone…
-
Calculating a final value from two selected values that exist in the same column?
I have two columns—one column has revenue, the other column states which quarter the revenue was collected in. Is there a way that allows a user to select a quarter to calculate the difference in revenue between the selected quarter and another selected quarter. So, I am basically looking for a solution that would enable…
-
Preview flow "from here" option?
I think I know the answer, but I thought I'd check anyway … Is there any hack to cause a Magic ETL preview to run from a certain point in the flow forward? I'm working on a flow that starts with some heavy sources and groups down before performing some merges and other heavy actions. I would LOVE to preview from a point…
-
Why doesn't the Date Settings feature in Magic ETL update my dates?
When I navigate to Settings and change the Timezone to America/Los Angeles, it doesn't change any of the values for my date columns. However, when I navigate to my input dataset in the ETL and change the time zone on an individual date field, it works as expected. Am I doing something wrong?
-
Data Snapshot
Ok so we have a dataset in one of our databases that periodically gets updated. Every so often, we have new data that gets added AND some of the old data gets modified. (Sometimes we have loans that get modified and we need to keep the original 'value') I am trying to create a snapshot of the original data - on a quarterly…
-
Resize elements in Dataset Lineage View
As a Domo user I want to be able to resize the right-, and left-hand navigation elements in the Lineage view of the dataset. /details/data-lineage In order to view the full name of datasets that have long prefixes. In the example below, datasets prefixed RAW_WebsitePerformance_GoogleAnalytics_****** you cannot…
-
Converting Dataflows
Having a "Convert" button in dataflows would be great for switching from one dataflow to another. For example, a MySQL dataflow to a Magic ETL.
-
how to aggregate nested average case statement
Business task: "what percent of this region's sites beat their target signups YTD"? So I want to take the average daily signup for each site within a region and see if it passes its target. If it does pass, it gets a 1, else 0. After this, I then want to aggregate it to the region level. So for example if 5 out of 6 sites…
-
UI/UX: Navigate to DataFlow input datasets directly from DataFlow overview screen
From the DataFlow Overview screen (<dataset>/details/overview), I want to be able to quickly access the overview pages for the input datasets of that DataFlow. I can get to them via the Lineage page, or the Direct Impact info, but I want to get direct, immediate access to each dataset's name and a direct link to it, so I…
-
Lineage of a field
Hi in domo can you find the lineage of a field , as in all the data flows or data sets a field appears in .
-
Ability to see/edit the process steps in a dataview
I've run into an issue where I need to update an older dataview or fix an error, but I can't get to the process step to fix it because it was done before a GroupBy aggregation step was done. When I tried to roll the dataflow history back to a point wher I should be able to see it I only get an error. Support wasn't able to…
-
Adding data that matches a date to a date dimension table.
I have HR data that has Start Date and End Date (or null) for each employee. I am looking to be able to see the number of active employees at any given date. I have added the Domo Date Dimension table to my data set, but I can't figure out how to join so that for any date I can get the count of employees who's start date…
-
To create ETL
I want to get a new etl by connecting two datasets. All stages are working, but they do not pass to the output part. When I press the save button, it does not save my work. Also, I was able to combine a data set and a file that was on my computer before using the "join data" command. Now this option is not active. I cannot…
-
What are best practices for combining huge datasets in Domo?
We have been using Domo for nearly a year now and are heavily utilizing DataFusion and Dataset Views to accomplish joining dimension tables to our primary fact tables. By the time we have joined everything we need, it is not uncommon to be looking at 300-800 columns and 50-100 million rows across 5-6 datasets. We often see…
-
How to create a column which SUMS based on the grouping of another column
Hello, I am trying to write an ETL which sums a value based on the grouping in another column (invoice number) which yields a column with the total quantity for each invoice. i have attached a simple table as an illustration of what i am looking to achieve. I do not want to write a formula where i have to continually…
-
Why do all Redshift Datflows (still) convert all variables to lower case?
Hi, we're currently doing an audit and noticed that legacy datasets have 2 versions, with the 2nd version just capitalizing the variable names (often a magic ETL). The first version is in Redshift - building dataflows in redshift is quite popular within our team because it has fuctions that mysql dataflows doesn't have.…
-
Breaking down bundles into individual items
Hello Everyone, I am currently pulling in sales data from shopify. We have a core range of about 20 products and another 20 or so bundles which are made up of those core products. I am hoping for some assistance with how to break down these bundles into its components (core products) as we would love to see how the core…
-
What is the best way to calculate?
So I'm using a grouped bar graph and am looking to try and calculate the difference between two of my columns that were created. My company calculates the average spread on loans broken down by lenders we use. I was able to separate those average spreads by product by adding the products to the 'series' drop-in at the top.…
-
Attempting to create unique rows for each possible value in a chosen column
Our business model currently offers multiple product options. I'd like to create brand new rows for each customer, 1 for each product, whether they own that product or not. My thought is to use new columns and then use a dynamic unpivot. Need help creating the new columns first though.. Currently have this: Account Product…