-
Data sharing rules
Once data is shared to a group, we currently have the situation where users in that group can share data to individuals. Thereby 'breaking' the concept of having the group. We need a way to stop that from being able to happen. I know current way of working is standard DOMO, but for us (particularly in relation to any…
-
Google Sheets connector datasets failing due to auth token expired.
Hello, I am seeing that something today happened for all of our google sheet datasets via connector are failing or having long run times due to this error message. "Domo is ready, but the authentication token is expired. Please verify your account credentials and try again" Does anyone know the resolution for this? I tried…
-
Dataset Direct Impact Reporting
In Data under the Overview tab, there is a section called Direct Impact. This data is very useful when doing Dataset maintenance as it will give you an idea of how that data is used. We would like to see this data reported in Domostats | Datasets so it could easily be pulled into any reporting that might be highlighting…
-
More query params for ListDatasets
Endpoint: https://api.domo.com/v1/datasets (GET) As a data engineer, I am trying to programmatically list multiple datasets using specific parameters. When I use the UI, I have multiple filters such as Last Run, Type, Owned by, etc. However, the datasets API only supports 'namelike.' It would be awesome if we can use the…
-
Approvals in-progress tracking
I love that each approval flow spins up its own dataset to track completions, but approvals only seem to show up after they've been completed with an approved, canceled, or denied status. It would be lovely if the dataset included any submission even if it's still in progress to better identify at which stage an approval…
-
Dataset Color Rules - lock color to column regardless of rules
Much of my data compares KPIs across 30+ different cities. When I use city on series, the colors are assigned in the order they are charted. So if I'm charting A-Z, the first in the alphabet gets for instance light blue. If, on another KPI, the default sort is by value high to low, the colors are completely mixed up.…
-
Collapse selected branches in Lineage
I would like to have the ability to collapse selected input and output branches in Lineage. This would help declutter the screen when tracing datasets and ETLs, especially when dealing with recursive ETLs that put two or more copies of everything downstream on the screen.
-
Dataset on Workflow Start Form
Hi, I'm using the brick "Workflow Start Form" available on app store to start a workflow using a custom form and parameters. That part works greate, but i alse need to query a dataset from there and the card have no option to link one (only allows to link a workflow). Can anyone tell me please how can I link a dataset or…
-
merging old data set and new data set
I have the old data set from one source that will not be update any more. The new data is coming from a different source. What is the best way, moving forward to merge these data together?
-
Conditionally Starting a Dataflow
I have a dataflow that I only want to start when the data in a dataset materially changes. It seems like it runs no matter if the data changes or not. Any advice on this.
-
Alert Configuration options differ across the DataSets
Good afternoon all, I am looking at setting up the Alerts on our DataSets and have noticed that the options for the configuration differ between different DataSets even though they are both powered by the same Connector. Version 1 - provides the option to apply the alert on the indivduals rows and apply filters (the one…
-
Domo Stats > App Studio views
I was able to see view of my App Studio content via the Activity Log dataset However, the item displayed is the page WITHIN the app that was viewed - and if the page name isn't really specific, it's not especially clear what app was therefore viewed. Please consider a parent/child relationship for activity tracking within…
-
Option to schedule datasets in UTC or local time
When we schedule datasets today, Domo schedules them in UTC, so there are no adjustments for Daylight Savings changes. This means that we need to reschedule datasets that must refresh at a specific time of day locally (i.e., 6 AM Central Time, regardless of whether we are in Standard or Daylight Savings time) twice a year…
-
Disable Views SQL Editor when it's been enabled
The SQL Editor in Views has proven to be invaluable when trying to fix other people's broken views. However, once the underlying SQL has been fixed I would like the ability to switch the view back to it's normal look and feel: most of my users don't know SQL and get freaked out when they see that big black box with the…
-
Dynamic Currency Symbol Formatting
Currently in Analyzer, number columns can be formatted as currency, allowing you to append one of 4 currency symbols to the beginning of the number in the chart. It would be incredibly useful to add a dynamic currency column option. Rather than having to select 1 currency symbol for the whole column, you could select…
-
Ability to remove unnecessary columns directly in the input DataSet before loading all its rows
The functionality I require is already available in the MySQL and Redshift DataFlow… …in this example deselecting "department" and "state" columns. This option would make it possible not to load all columns for all rows in the DataSet. I hope it will be available in the Magic ETL input DataSets as soon as possible. Thank…
-
Issues with Average Function
I have detailed biweekly pay data where I am looking for the average hours worked in every region per week (using a basic calculated field). This functioned well for 6 months but became an issue at the start of the year. Rather than finding my typical averages, suddenly the data is showing me trillions of hours in every…
-
Issues with changing cast dataset to date
Hi! I am trying to change the data created column to date, but when I check append rows, it says the column is changing to timestamp. I am not sure what I am doing wrong.
-
Reloading Recursive Dataflow Data
Hello, I have a recursive data flow running daily adding on and updating our sales data. It was discovered that the join wasn't using a fully unique identifier so some rows of data have been cut out over time. I want to clear out the data and resend it all to domo so that I make sure I have it all. Is there a way to clear…
-
Maintain Input DataSets when Pasting Copied Magic ETL Tiles
Currently, when copy and pasting Magic ETL tiles between flows, input tiles are scrubbed and become a plain input tile without a DataSet selected. I understand why you'd want to scrub this if pasted in the same flow, but it should be maintained when pasting in a different flow. This should be relatively easy to implement…
-
Replace personal identifiable information with avatar
Has anyone ever replaced a user's information with a non-identifiable avatar in a table on a dashboard? Here is the use case: We want to show a snapshot of what was recently watched on our video streaming platform. Our model is that a group buys a subscription, and then all its members can use the platform and watch…
-
Upload large JSON files
I have a JSON file located in a google drive folder, the file is 12GB so is too large to use the file upload connector. Is there a workaround on this to be able to upload the JSON file into Domo whether is directly from the computer or importing it from google drive?
-
Add a governance dataset for DataFusions to identify datasets used as inputs
Governance data is readily available to identify input datasets for dataflows and dataset views, but there isn't a governance dataset for DataFusions that allows the same. We need the same visibility into how DataFusions uses datasets as any other object in Domo.
-
More Dataflow suggestion: When I "cancel" out of a data flow don't dump me back to the Dataflow page
It doesn't always happen, but when it does, UGH. I hit cancel when in an ETL and then I go all the way back to the All Dataflows page. I don't want to go that far back. That's not even where I started. It seems to depend on how I get to the ETL. In this case I can be in the Overview page, click edit etl, once in the etl I…
-
I'm pulling in a column from Salesforce that has over 1024 characters - Text column type limit
Is there any way I can overcome the limits of the text column? and are they really 1024 characters? What are the possible solutions to have the entire text available in my DOMO dataset?
-
Is it possible to batch edit source data?
I have a large dataset that needs some cleaning. We have appended to this dataset daily over several years and some of the data values have drifted over time as users have renamed what are essentially labels for different entities. If this were SQL, I could write an update statement and quickly replace the values in label…
-
Extracting Data from SharePoint Excel spreadsheets
Hello everyone, I'm in the process of setting up financial reporting in Domo. Our FP&A team processes financial data and then stores it in two specific Excel sheets within our SharePoint. I'm looking for the most effective method to extract this data into Domo, creating a dataset that can automatically update with new…
-
Retrieving Data from a partner's Domo sit
Hi everyone! I have been using Domo for a little under a year. Today I realized my organization pulls data from one of our partners domo dashboards manually which is then uploaded into our domo data each month. Is there anyway to create a pipeline between two organizations Domo sites to feed our datasets?
-
Recover a deleted dataflow
Hi, I was doing some cleanup and deleted some datasets that resulted in the deletion of a dataflow. Is there a way to recover deleted dataflows? I noticed a deleted dataflow could be recovered if you find a link to it: —but I can't find a link to the dataflow I need. Thanks.
-
GA4 Weekly and Monthly data - should I schedule a better import or make an ETL?
I'm not sure which direction to take - has anyone dealt with GA4 weekly, monthly, and yearly datasets before? I've realized that if I need to get a summary number of users over a certain time period in GA4, the only true way to make sure they are not double counted is to make separate datasets that pull in users by day, by…