-
Data Science - Outliers
Hi, New to using the data science tiles in ETL. I have a dataset with sales by category by day. I can run this through the outliers tile for one category and it will correctly mark the outliers. What is the best way to do this per category? Thanks
-
Dashboard Editing
When I create a new dashboard it allows me to edit the format, add text, etc. initially, but once I save it, it does not allow me to edit it again. When I click the wrench, it gives me two options: Add to Favorites or Open Conversation. From other guides/screenshots it seems like there should be many more options to choose…
-
Rolling 12 Month Average in Magic ETL
Hi there! Was hoping someone would have a solution for what I am trying to do. I want a 12 month historical average in line with the current month in my dataset. (Sample datasets will only show 3 month) This is a sample dataset of what I am working with: *"Desired Column" would be the field that holds the historical…
-
is there anyway to change default time in Domo?
Seems like date/time format always defaults to 12:00am. Is there anyway I can change this universally so that it always just defaults to 11:59pm when no time is specified in date/time format?
-
How to extract a substring from an URL
I'm trying to extract the substring from an URL. Input: www.abcd.com/level1/level2 The output I'm looking for is essentially taking from the first character to the position of the second '/' minus 1. I wonder how to write the formula in beast mode. Desired output: www.abcd.com/level
-
BeastMode: New Field with Multiple Column Criteria
Pretty sure doing in ETL would be preferrable however looking for a short term approach as our dev resources are tied up. I have a data set something like the picture below. Its a data set that displays ALL USERS that have access to Application 1 (App 1). It Also shows when a user is a manager and the client they are a…
-
WorkFlow Code Engine Help
Good morning, I am following along with the below Workflow Onboarding video from Dan. He mentions having a separate video for making a new code engine package, this one titled Page Manipulation, I was wondering if anyone had the link to that video, if it…
-
Unable to get the value of a canvas
Hello Gurus, I am trying to get a value of canvas which is coming as a aria-label using JS after the iframe is fully loaded. I have highligted the value which I need to get after iframe is fully loaded. For that I am using the following code snippet, in this code I am able to get the document part of the iframe, but when I…
-
Release Notes - What Changed
Many times new releases add additional things which aren't documented and can silently break dataflows and metadata which we rely on to properly administer our instance. Can we get a list of things that have changed in the release to see what issues we might be running into when monitoring our instance? Could we also get…
-
Option to Remove Participant Filter
In DOMO, there is an option to remove "Allow adding of new filters" for a Dashboard, but this removal only removes the ability for the Participant to save filters for all who access the card. I was interested in not allowing the Participant to save a filter at all and that is currently not an option. I am proposing to have…
-
JSON Connector with JWT
I’m hoping to pull in some data from Prisma, they have a pretty standard API pass a username and password to /login get back a JWT token and then put that token in all further calls in a custom header field and have to login again after 10 mins. The main API is JSON (with quite a few arrays inside arrays) I notice a couple…
-
Multiple values in Single value card
Hello, I am using a Single Value visual on the dashboard. So basically I am displaying the current value on the card. While I show that value, I am seeking to display its, Previous and Next values as well. I am able to use the subtitle for one value. Besides, how can I display the other value? Thanks in advance.
-
Notification to Owner when Card returns 'An issue has occurred during processing' error
When working with complex beast modes, or even simple ones where the data types might not suit, the beast mode might validate as ok, but an error is returned because the calculation can't be completed. This is great when you're editing a card, however on occasion a card may result in this error due to the incoming data…
-
Dashboard Editing for Different outputs
Currently under the 'Edit Dashboard' option, there are 2 options to choose from: Desktop and Mobile. These are really powerful for customising the layout and sizing between the two device types, however the mobile is really specific for phone, and when viewing dashboard on an iPad/tablet the customisation doesn't render…
-
Anybody out there have experience connecting to D365 Finance & Operations?
Hi, we want to utilize this connector but are having trouble finding and setting up the required credentials. Any advice or resources sent our way would be extremely helpful! Thanks, Paul
-
Xero connector
I need to setup the Xero and Xero payroll connectors. I have completed steps 1-4 in this help article (including purchasing the custom connection subscription from Xero) but need some guidance on how to complete steps 5-7 please and to activate the connector in Domo. I have basic technical knowledge! Any help would be…
-
How to see active subscriptions without copying rows?
I have a dataset that has subscription data (Id number, Start Date, End Date) and I need a way to see how many are active on any given date. A line chart with the date on the X axis and a Distinct Count of the ID as the Y axis would be my preferred visualization. Using start date or end date as the x axis does not work…
-
Error Log for Workflows
How can I find the error log when I get an error in deploying workflow? See below: Failed to deploy to workflow engine, see logs for more details. Message: Command 'CREATE' rejected with code 'INVALID_ARGUMENT': Expected to deploy new resources, but encountered the following errors:…
-
Surface more details on connector indexing errors to help us to be able to see the cause.
The error we see in Domo: Domo has received your data, but there was an error in processing. This will automatically be corrected the next time this DataSet runs. Error details extracted from Support: "Indexing failed: Empty primary key at row "0" column "Ordernumber", If more of the message was shown in the front end of…
-
Magic ETL Tiles groups for clearer organization and visibility/observability :D :D :D
Although similar to the "Allow users to specify the color of Magic ETL tiles", we sometimes (okay, often) have extremely long and complex Magic ETL's that are difficult to comprehend, especially if you're inheriting them or exploring for replication or use. Being able to "group" your tiles in some fashion would greatly…
-
Arranging a Filter in Alphabetical order
Is there anyway I can arrange the values in a filter using a beast mode or something so that the dropdown values are in alphabetical order
-
Ability to sort Filter Views
Filter views are a very powerful way to quickly filter data down to what you want to view on a page without having to set the filter each time. Problem: These views are currently stuck being in the order in which they were created. If they are needed in a specific order, they have to be remade to be in the desired order.…
-
Single Value Card - None
Hello Folks, I am using Single Value card on my dashboard. For example, there are 10 distinct names in the column selected in the Single Value card. In the dashboard, if I select any name on any visual, the selected name is displayed in the single value card. But, if I don't select a name, I want it to set to a default…
-
Can I turn over provisioning of new Domo users to my internal IT team to handle it all using Okta?
Hi all- I found these reference links: (appears that provisioning is *NOT* supported) (appears that provisioning *IS* supported) And this forum thread: But it doesn't seem 100% clear to me on whether new Domo user provisioning can be handled totally by Okta without manual steps in Domo for each new user added (outside of…
-
DataFlow Failed with no usable explanation
I have a dataflow that i was able to run successfully on a small sample dataset. I attempted to run this same dataflow on a dataset with around 429K rows of data but after 10 hours, the dataflow with an error message of "Failed while executing There was a problem running this DataFlow". I am curious if there is a timeout…
-
Unleashed connector
Hi I am new to Domo and would like to use the connector for Unleashed however it doesn't have the option to pull in the Sales Quotes table. Can this be added to the Unleashed connector as it is available through Unleashed's API? If not, can I use the JSON connector to retrieve this table and if so, can you please provide…
-
Color rules for Multi-value cards
Our company is currently using several multi-value cards to show summary numbers compared to goals. The multi value cards do not allow for creating color rules for when a value is = the goal value. The only option is to reverse a color rule, which then has to be changed back once the value is above or below target again.
-
April 2024 Community Forum Highlights
Hello Domo Community! How is it already May?! Nonetheless, it’s time to post the April Community highlights. The Community has been growing steady over the course of the last year, and it’s showing! Discussions, posts, and reactions have 4x what we’ve seen in the past. And every single question asked on the Community…
-
Embedded cards using APIs with pfilters - graph by options
Hi Community, I have been embedding cards using the API with pfilters. This seems to be working well but some graphs are defaulting to graphing by day vs hour. I know I can adjust this within the card but wondered if anybody had any luck programmatically adjusting this. The documentation for APIs is a little lacklustre and…
-
Color rule based on category %
Hello, I am trying to find a way to add color rules based on category. This is an example - this is a pivot table showing all the orders based on category by week. Each category has a different range that needs a color rule say for category 1 - it should be less than 5% to show green else red but for category 2 - if its…