-
How to create a custom roleto edit cards/dashboards, but only view (not edit) dataflows and datasets
I want to grant some users access to maintain and update their dashboards, and the ability to view the datasets and dataflows. I don't want these users to edit the dataflows or datasets because they feed several other dataflows and dashboards, but in the edit role data grants, I only see "Manage" or "Edit", no "View" level…
-
Year-over-Year Sales Unit Comparison
This comprehensive report is crucial for businesses aiming to track performance and make informed decisions. By comparing sales units from the current period against the same period last year, stakeholders can gauge the effectiveness of their strategies, identify trends, and adjust operations to enhance profitability. The…
-
App Studio Controls/Filters
While creating apps with multiple pages/tabs we don't often use the same dataset for each card we put on a dashboard (app in this case, woohoo for app studio!) Where we are running into trouble here is that page filters only have the option to select a singular dataset rather than all datasets where the field is present.…
-
YouTube Connectors Using YouTube Account Username and Password
Hi Domo Dojo Community, I've been setting up some test YouTube Connectors in my Domo account. I'm using the Username/Password of the YouTube account to make the connection. So far, no data has come in and its been several weeks. Are there other barriers or settings which I can investigate in order to successfully connect?…
-
How to import date/time values in workbench exactly as 8/26/2024 9:00:49 AM, without any transform?
I am using the Domo workbench to import data that includes two fields, OrderDate and TransactionDate, which are in date/time format. My goal is to import these date/time values exactly as they are, without any modifications or timezone shifts. For example, if the OrderDate is 8/26/2024 9:00:49 AM, I want it to be imported…
-
Grand Total to Show as Average instead of Sum
I'm trying to get my Grand Total for Revenue as an example to show as an average instead of a sum in a Mega Table. My Revenue calc is below. SUM (CASE WHEN (`Source` = 'Order Items' AND `OrderItems.Type` = 'SpaceOrder' AND `Rank_DateRunOrderItems` = 1) AND `Reservation.State` != 'Canceled' AND `Enterprise.Name` IS NOT NULL…
-
Making Users Watch Mandatory Videos
Hi, Im not sure if this is possible within DOMO but has anyone set up their instance where users have to watch a video or two in order to gain access to content? I am trying to create training videos that is required to watch before being able to use DOMO. Any advice would be great!
-
Is it possible for a WorkFlow to update a column during Various Users Tasks?
I'm developing a WorkFlow Process that has a few user-based tasks. The workflow is triggered by the addition of a Form Submission that will update a Dataset. As the Workflow progresses (users approve tasks), I would like to have a service automatically update the status in the original Form Dataset that will be used for…
-
How to identify workflow initiator
I have numerous use cases where when a user initiates a workflow they will need to be sent a notification email, eg after an approval action, "Your request has been approved/rejected" or validating* a form input, "The email address is incorrect, Stuff@stuff is not valid". The only way I can see to do this is to have a…
-
Best practice for using the same dataset for different projects
So my team has a Sales dataset that is being used to make a Sales App, this dataset has variables, BeastMode calculated fields that use those variables, and these BeastMode were saved to the dataset when created. Now I'm making a new app that also using the same Dataset, however, I'll need to create different Beastmode…
-
Dynamic Chart Height
I would like to have the option (when creating a story in Domo) to define a minimum and maximum height for a table card. Let's say that I have a table that shows Today's large sales. Our executive team likes to have visibility to any purchase over $100,000s. When I create this card, I currently have to estimate what I…
-
Adaptive Dashboard Sizing for Different Screen Resolutions
Can the dashboard size be fixed based on the browser and system screen resolution? Currently, there are only 'Fixed" and 'Auto' width options. However, even with Auto Width selected, if the browser resolution is set to 67% or 75%, the filter titles and bar value get hidden, which is a concern for the client. I believe…
-
Enhancing Dashboard Aesthetics with Custom Borders
Currently, the dashboard only provides an option for vertical borders. Can an option be introduced to add horizontal lines or smaller border to better partition cards and highlight specific sections? This enhancement would improve visual clarity and provide a more structured and aesthetically pleasing dashboard layout.
-
Scroll Bar in Bar Charts
I would like to suggest the possibility to add (optionally) a scroll bar within the card’s dashboard view like the expanded card view, when the "limit row" is not an option due to customer needs. That because when a Bar Chart with a lot bars is placed in a small place into a dashboard, The card's automatic solution is to…
-
Should domo.onFiltersUpdate() get triggered if the user clears all filters?
Currently I have an app framework app that uses the domo.onFiltersUpdate() to handle users interacting with the page / card filters on a dashboard. It works great as the user is interacting with the filters, and I receive the new filters object and can do with them as I need. However I've noticed that if the user clears…
-
Ownership of API Clients
Hello, We have a user that has left the company and they have created numerous Client APIs that are being used in integrations throughout our company. How can I transfer ownership of those clients so we do not need to reissue new clients and update all integrations using them. Thank you.
-
Why are all of these dates (Due_Date, PO_Date, Print_Date, Ship_Date) returning the date - 1 day
When I run the following query in SQL Server, four date fields (Due_Date, PO_Date, Print_Date, Ship_Date) return the correct date, but when I run my query in the workbench, the resulting 4 dates are -1 day (Example: date when run in SQL Server = 2023-05-04-00.00.00.000000, the correct date, but when run in the workbench my…
-
salesforce writeback batch append question
I have a dataset that has data flowing in batches and every batch group ( has a unique group name (column) , I want to writeback this data as it comes after necessary transformations to the same writeback connector to append only unprocessed records. While trying to do this, I get " it is illegal to have 2 inputs where…
-
Import App Pages
In App Studio when you go to page to import there is an option to import app pages. When I select this, only the Apps are available for selection and not the pages within the Apps. I think this is a bug and should allow for import of the pages within other Apps. Is anyone else having this same issue?
-
Removing leading zeros from PO_Number, (using OPENQUERY)
I've tried the following 3 things to remove the leading zeros from PO_Number, (using OPENQUERY) in the workbench without success, any other suggestions please? Using CAST and LTRIM: SELECT * FROM OPENQUERY(ACME_CO_PRD, 'SELECT LTRIM(CAST(CAST(fd.PO_NO AS INT) AS VARCHAR)) AS PO_No, 2. Using PATINDEX and SUBSTRING: SELECT *…
-
Announcing Domopalooza Speakers!
Meet Darren Hodges of U.S. Bank! As EVP and COO for the Wealth Management and Investment Services org, Darren oversees many key operations at one of the largest banks in the United States. Hear firsthand how Darren uses Domo to excel in his role and manage critical functions, and walk away with real applications to invest…
-
Bulk Filter Paste For App Studio
A couple months ago DOMO launched a bulk copy+paste filter function for Dashboard filters. Currently, this functionality does not work for the App Studio. It would be great to have that be a universal capability across DOMO as it's very helpful when filtering for 100+ items.
-
Domo Mobile App Access for App Studio in Subscriber Instances
We have a client who uses a subscriber instance and when we download the Domo App and try logging into the URL for the subscriber instance to access their Apps our SSO does not work. We get an error message: "Could not sign in - Mobile access has been restricted by your company. Please contact your MajorDomo for more…
-
ETL fails due to "This data set does not support data version filtering."
I have my SQL raw dataset set to merge new rows which is working correctly: This SQL dataset is the input for my ETL attempting to process New rows then Upsert in the output dataset: However my ETL fails to run due to the stated error: Am I setting something up wrong? My raw SQL data is not partitioned but it is using the…
-
DELAYED--1/29 PRODUCT RELEASE SNEAK: PDP Column Policies
Update 1/24/2025: Sadly, we have discovered a few bugs that were not yet resolved with this beta feature and this it will not be included in the 1/29 release. The feature will remain in Beta and you can contact your Domo representative to be added to the Beta. We look forward to moving the feature to GA in March. With PDP…
-
Magic ETL Column Search Improvements
The new Column Search feature is a godsend. But … it could be better with two modifications: Add a Match String checkbox to limit the search to match the text string exactly. I was searching for the source of a field in a very large ETL. It turned out that the name of the one I wanted (countAsCar, for example) is included…
-
Editable "Form"/Survey Style to Log Interactions
Team, Is there a functionality within Domo wherein end users can log interactions? Something like this: I tried to build out a Form in AppStudio, but all end users got an "Error Loading Form" issue (see my separate thread: Any ideas?? I've thought about making a Google sheet that was connected to Domo but that feels clunky.
-
Data Join Confusion - Magic ETL
Hi, I'm trying to join two sets of data together (assignments submission data & assignment summary data) For the output, I am trying to get a list of all assignments with a due date in a date range that have not been submitted by the students. The assignment submission data has a row for every student that lists every…
-
Datasets API - Get Metadata - RequestedParts
The documentation for the dataset-get-metadata endpoint here indicates that the "requestedParts" parameter can be used to specify which parts of the metadata are needed in the response. However, the documentation does not indicate list of accepted values. The sample request below also indicates a different param named…
-
how to mimic this report on domo.
How to build this report on domo.When i export to excel.It should exactly look same .which chart type should we use