Dataset
Discussion List
-
Does SQL editor for Dataset views support Common Table Expression (CTE) ?
Title: CTE Support in Domo Dataset Views Hi fellow Domo Developers, Has anyone successfully created a Dataset View using a CTE (WITH clause)? I’m currently trying to build a Dataset View using a CTE, but Domo throws an error and appears to interpret the CTE name as a source dataset instead of resolving it as a CTE. I…
-
How to find anyway to Report on Column Usage in Cards
We're currently reviewing our datasets to eliminate redundant and unused columns. Is there a way, through DomoStats or a Governance report to determine which columns are being used by cards and which columns have no usage across the platform?
-
Domo Community Declining - Oliver to Blame?
Hi my fellow Domo Sapiens, I've noticed a drastic drop in community activity now that the chat agent, Oliver, is present on the landing page and able to help answer questions. "Softball" questions (easy ones that I could answer) are less common now that Oliver handles the easy ones. While I do appreciate the efficiency of…
-
Accounts - Reassign datasets
I would like some additional functionality built into the reassign option. Specifically, functionality to allow you to pick what datasets you want to update. Currently it is all or none, which can include datasets you don't own, which will fail and give a generic error message. I was attempting to flip 100 datasets to a…
-
Feature Request: Ability to set a default Time Zone for Dataset Scheduling
Idea: Please add a global or user-level setting that allows us to change the default time zone used when creating new dataset schedules. Currently, the scheduler hardcodes to UTC every single time a new schedule is created. Why this matters: While Domo allows us to see our local company time zone alongside UTC, having to…
-
Save Filter View for Dashboards & App Studio Pages with Selected DataSet
For dashboards and app studio pages that consist of cards across multiple datasets, the page filters are automatically set to the first dataset in an alphabetically sorted list. However, there are often situations where 1 dataset may not contain all the values as another dataset for a column intended to be filtered on. The…
-
Mimic a User's Access to New User
It would be nice to be able to go to a user, look at the pages and cards they have access to, select all, and share with a new user that's being set up. I know groups is a good way to manage access easily and efficiently, but sometimes it's nice to be able to mass mimic access at the dashboard and card level, especially…
-
Coloring Option for only the rows title instead of entire rows
We need to color only the row name's current year, Month and week instead of entire rows.
-
Enhance PDP to Allow SQL Filtering
PDP is currently limited and does not allow users to permission based on a condition in a given column/row. Current State Example: The group that runs the farmers market can see the revenue that each vendor generated. Each vendor should be able to see the quantity sold for all farmers market sales, but they're not entitled…
-
Tag documents or link documentation to datasets for AI model reference
When building out a semantic layer in domo it would be helpful to have decision rules documents that any AI model could reference. For example: someone asks the AI model built off a domo data set(s) about a question that requires some background decisionm analysis. If that decision analysis is already attacehd to the…
-
Datasets creation and adding the data
I am ingesting the data into the datasets using the api calls. I had earlier created these datasets using api call. Now, when I am trying to insert the data to a different dataset ids, the ones created using Workbench or manual uploads, I am getting a 400 Bad Request error. My question: Is there a restriction to use only…
-
Error When Opening Any Dataset in Vierws Explorer
For about a week or so whenever open a dataset in Views Explorer it shows no data only this error Anyone know what is going on with this? I was looking through the posted questions and couldn't find others experiencing the same problem so I'm wondering if there's issue somewhere in our Domo environment. Thank You!
-
Semantic modeling - support for repositories needs to be added
We are taking part in the semantic modeling beta. The feature is coming together nicely and we were looking forward to using it behind some of our dashboards. However, we're running into problems on this front: it's currently not possible to use repositories to deploy a semantic model from one environment to another. On…
-
Can we use a semantic model as a data source in Magic ETL?
I'd like to use one of our semantic models as the basis for a new dataset, rather than having to recreate all of the joins in Magic ETL. Is it possible to use a semantic model as the input to an ETL? The only workaround I've come up with is creating a table card from the semantic model and exporting the data from that, but…
-
Set default formatting for a field (on cards) on the dataset
I hate adding currency fields to cards in DOMO, super frustating.. EVERY time I have to do this: format Set currency to $ remove decimal places I'd like to set this once (as a default) at the dataset level.. then be able to override in card if I need to.. Save so much time..
-
Are variables linked to datasets in beta yet?
At Domopalooza, I heard about the ability to link a variable's values to a list from a dataset. Is this in beta or released yet?
-
Replicate Magic ETL Refresh Trigger To Views
Piggy backing off my other idea linked below, I am suggesting that similar to how magic ETLs can be set to refresh only when chosen datasets have been updated, port that same functionality over to views, so that a view's metadata doesn't register as updated until all the source objects have updated. In the example below…
-
Control ETL Trigger Refreshes Based On Root Datasets Or a SQL Query Result
Currently we have a Domo view that is comprised of 4 or 5 different datasets. These datasets individually refresh the time between the first dataset updates and the last one updates is about 5-10 minutes. I have ETLs that have this singular view as my source input, if I put a trigger condition on it for when datasets…
-
Provide Field Definitions for Domo Stats and Domo Governance Reports
There are knowledge base articles listing out which fields are included in each report, but those fields aren't defined anywhere. Some field names can be a bit ambiguous and it would be nice to have definitions of what each field means.
-
Dataset Deletion - Disable Upstream Dataflow Branch / Allow Upstream Dataflow to Still Run
When viewing a dataset, you can see the downstream impact of deleting that dataflow. The problem is, if you delete a dataset that is an output of a dataflow, it makes it so that dataflow can't run. This is an issue if that dataflow has multiple outputs and other outputs are still needed. It would be nice to have the option…
-
Inheriting PDP policies for a given user when querying the dataset?
Hi, So we're trying to build a user facing app that will be fed DOMO data. In particular its a chatbot that will be able to query and read in DOMO data for user insights and actionable recommendations. The issue we're facing is, each of our users have particular data policies and these policies are encapsulated in a PDP…
-
Add “Delete and Replace” update method option for connectors returning 0 rows
Posting on behalf of customer - Currently, when a connector using the “Replace” update method returns 0 rows, Domo preserves the previous dataset contents to protect downstream assets. While this behavior is understandable, some use cases legitimately expect datasets to clear when the source returns no records. A…
-
Field contains apostrophes(') likely introduced through HTML encoding, showing differently in hover
Field contains apostrophes (') introduced via HTML encoding, causing inconsistent rendering between table cards (which display values as-is) and bar charts (where apostrophes are missing or altered in hover text/tooltips). Beast Mode REPLACE functions did not resolve. How to solve this functionality. eg: " "
-
Set explicit variable value from card click
This is an addition to the current set variable functionality. Allow the specificiation of the value to be set by card. i.e. if I have a title/text card that says Applicants Year to Date, let me specificy that clicking that card sets a variable to "Applicants YTD". Ideally the value it sets would be customizeable and not…
-
Qualtrics Connector Failing for Report "Distributions"
We have a Qualtrics connector set up to pull data for the Report Type = Distributions that has been failing. The other connector we have to get Report Type = Survey Responses is working correctly so I don't think it's an account or authentication issue - has anyone else been seeing this issue? This is the error coming up…
-
Semantic Model Feedback
I want to love the Semantic Model functionality that's currently in Beta, but it needs a lot of features added to bring it closer to what Views can achieve. Normally, I'd prefer a Semantic Model to a view. They're similar in function, but a model improves traceability and documentation, especially for low-code/no-code…
-
Have Viewable Settings Tab for All Datasets for Admins
I've run into limitations on datasets in being able to see the settings tab, even as an Admin with every grant selected and making myself co owner of a dataset. As I am trying to manage datasets, this is very limiting in being able to see how a dataset is configured, scheduled, etc. and it would by nice if this limitation…
-
DOMOStats - Card View Count?
Is there a DOMOStats report that provides Card view counts? If not, what would be the best method as a workaround to capture the count that appears on the cards? I have gotten close by trying to capture user's activity viewing specific cards, but there has to be an easier way to do this. I found DOMOStat report: Card Load,…
-
Announcing the Datasource Swapper: Move your existing Cards, Views, and ETLs to new datasets in bulk
Hi everyone, I am excited to announce the release of the Datasource Swapper! Whether you are building new datasets because you are moving to a new data provider, transitioning away from materialized datasets in favor of Cloud Amplifier, or dealing with forced changes caused by vendor API deprecations, this tool was created…
Upcoming Events
-
Domo Connections Tour | SALT LAKE CITY, UTAH
If you're in the Salt Lake City area (Domo HQ in American Fork to be exact), on Sept 29, this is the place to meet up with your local Domo Community! Get into details with the optional technical workshop before lunch, or just come at noon and network before the event. You'll hear product details from Domo Experts and enjoy…
-
New User Launch Webinar
Whether you’re new to Domo or adding new users to your team, we want to help your team get up and running faster and make it easier to find the resources available to support your success. Why attend? Get oriented faster and avoid common early roadblocks Learn where to find answers, training, and support Discover ways to…