-
Connect with Domo users at a location near you! Register for Connections Tour *FREE EVENT*
We're excited to connect with many of you in-person during our Connections Tour throughout September and October. This half-day event is completely free and will include a technical workshop, unique swag, networking lunch, and great speakers. Domo is hitting the road to meet-up in 11 different cities: Chicago, Minneapolis,…
-
App to App Persistent Filtering
I would love to have the ability to be in one app and open another app and persist the filters to the second app. My use case would be a sales app that contains a button that could open another customer app. I would like the user to be able to select products from the sales app and then click a button to open the customer…
-
Combining Multiple columns into one column using beastmode
I am making a table card that uses multiple different rows. The way I am doing it is creating a variable named 'unit type' that when set to specific values returns a specific column. It then sets all the rows for which that column is blank to null and finally I filter out any null values. bellow is the beastmode I used,…
-
Trying to show Churn (%) as a percentage and Churn (#) as a regular number
Basically What the title says, I'm trying to figure out what I need to add to my beast mode to be able to switch between the unit type on the axis. I want to display Churn (%) as a percentage (without multiplying by 100) and show Churn (#) as a number. Attached is the beast mode that I have so far
-
More role permission granularity
There needs to be more granularity around the permissions that can be assigned to roles - specifically regarding the permission grants offered for Role and User management. There needs to be alternatives to the current 'all-or-nothing' options of 'Manage all roles' and 'Manage all users' permissions. I created a custom…
-
Cache configuration
Hello Folks, I understand for a Federated Connection, the DOMO cards will fire queries directly to Snowflake. However, I have few questions around this: Will there be any cache stored at card level? Will there be any cache stored at user account / user session level? Will there be any cache stored in DOMO for my connected…
-
Click to select, not deselect
Is it possible to change the filtering option so when an attribute is clicked (in a legend for example) it filters by that value. It currently deselects that value from the data
-
Sub Directories in SFTP Connectors
Sub directory paths need to be enabled in the standard SFTP connectors. Limiting the ability to the root directory is too limiting as most people do not write to that directory and some are not able to. Please make this an option.
-
Logic - link original submit date to all subsequent back orders
Hello. I'm wondering if anyone has ever had a similar scenario/concept and have come up with good ways to achieve the desired outcome. I've attached a screen shot of real data. The goal is to get the submitted date of 7/5/2024 (A6) linked to orders in rows 7 and 8. The story of this data is that order id 16403748 was…
-
can I change the pivot table chart like this? help please
I want to move the value to above the month metrics so I can compare numbers in the same table. Value 1 | Value 2 … by month % | % .. by month
-
Date Filter to Omit Last 45 Days
Does anyone know if there's a way to set the date range filter to exclude the last 45 days but still give YTD numbers? For example, today is 8/19/2024 and the last 45 days is irrelevant to a certain set of data we have so I would want to look at July 5th and earlier. I know I could use the "Between" filter to just go…
-
NPS Calculation Through BeastMode
I'm trying to do an NPS Calculation through a beastmode and have already converted the "NPS-Value" column in another beast mode to Scores (9-10) = Promoter, (7,8) Passive, (0-6) Detractors. I'm trying to do the promoters - detractors / total *100 function in a separate beast mode but can't get it to work properly. What…
-
Calculating individual value as a % of a column
Count Total Weight % of Weight 12x2pk 2,525,985 23.65% 12x4pk 169,092 1.58% 14ct 630 0.01% 16ct 8,505 0.08% 20ct 175,140 1.64% 22ct 239,400 2.24% 25ct 143,325 1.34% 28ct 395,640 3.70% 30ct 310,275 2.90% 32ct 1,196,370 11.20% 35ct 2,997,225 28.06% 39ct 787,185 7.37% 45ct 1,665,090 15.59% 52ct 68,355 0.64% If I have the…
-
How do I count the values in a column using beast mode?
14.76K is the total number of students (Both full-time and part-time). What would be the formula if I only want to count the Full-time values in the Full-time/Part-time column? And then if I want to change the count to percentage, do I need another formula for it? Thank you.
-
How to Use Partitioning to Retain Data in a Monthly Rolling Window Dataset
Hi Domo Community, I’m currently working with a dataset (via MongoDB Connector) that operates on a 12-month rolling window, where data older than 12 months is deleted on the 1st of each month. Long story short, I cannot change this configuration. But, I would like to retain some of this older data using partitioning before…
-
Group By Tile to JOIN Tile Produces Unexpected Result. Using an Output Tile as an Input Fixes It
Greetings, I have aggregated transaction data using the Group By tile to produce the following schema: Project ID (GROUP) Amount (SUM) Labor Cost (SUM) I then join this dataset to a list of transactions which are also grouped by Project ID. Left table = = Transaction dataset Right table = = Grouped dataset from above…
-
Writing a Beast mode for a table card that selects a column and only displays rows with values
Hello, I am trying to write a beastmode for a table card where it picks a specific column based on a variable then only displays the rows in which that column has values. I know how to make a variable to select columns, but I can not get it to leave out the rows in which that column is blank. The first three images are…
-
Error in workbench, Dataset is currently locked and cannot be executed right now
I created a dataset with the following SQL query 6/1/24, and on 8/8/24 I began getting the following error: The dataset is currently locked and cannot be executed right now. The likely cause is the Job is open in the UI or has unsaved changes. I have confirmed that the job is not open in the UI and has no unsaved changes,…
-
Append a Dataset using Domo API
We are trying to append data to a dataset using the "Import data into DataSet" DataSet API Platform(OAuthAPI) documentation. https://developer.domo.com/portal/4ba1c85b30ae1-import-data-into-data-set When we use end point "https://api.domo.com/v1/datasets/{dataset_id}/data?updateMethod=APPEND", it replaces the data in the…
-
Rotation of Domo app on iPhones
It is not currently possible to rotate a dashboard on the Domo app on an iPhone. This can be done on Android devices. It would be helpful if we could also rotate on iPhones to make dashboards easier to view.
-
Period over Period Beast Mode
I have the following Beast Mode working for a comparison table (Period over Period is the name of the variable: CASE WHEN Period Over Period = 'Week over Week' THEN (CASE WHEN WEEK(Date) = WEEK(CURDATE() - INTERVAL 1 WEEK) AND YEAR(Date) = YEAR(CURDATE() - INTERVAL 1 WEEK) AND DAYOFWEEK(Date) <= DAYOFWEEK(CURDATE()) THEN…
-
Parse data with no header
I have an API which pulls in data {"name":["details"],"name":["details"],"name":["details"],"name":["details"],.. If I MagicParse this I just get ONE long row with these details. What I am after is 2 columns of Name and Details. I have parsed the data and added the columns titles but how do I reference the data? for(var…
-
I am struggling to make all the font styles on an App match, any ideas?
It seems like every element I add has it's own font style, and I also can't figure out how to make this variable display without a comma. When you try to edit config it only allows me to do default, %, or currency. And where you edit styles the font style choices aren't very intuitive, at least to me. Is there a way to set…
-
Extract the string values in between stroke and question mark in a URL
Hi Domo, I am looking for a way to extract the string values in between stroke and question mark in a URL Example URL: https://dam-bc.com/content/67-making-AI-trustable.pdf?_gl=1*ckt29z I want to extract this part of URL: "67-making-AI-trustable.pdf" Ideally if I can do that with a beast mode formula would be great. But if…
-
Data storage
Hello, I understand any data coming from files and output datasets from DOMO ETLs shall store data in DOMO Cloud. Any of the following shall also store in DOMO Cloud? DataFlows SQL View (DOMO) Adrenaline Transform What if I use federated connection as my connector? or an API to retrieve data from source and leverage any of…
-
Export all data at once
After troubleshooting with the DOMO team, they determined there is no way to export all the underlying data (not just curated datasets) at once. I would like to have the ability to export a CSV with the entire universe of the underlying data from DOMO to facilitate our ability to explore it outside the DOMO platform before…
-
YTD, YOY, M-1
Hi All, I want to create a column for YTD, YOY comparison by month and M-1. Example output is below: I have datetime in a format at yyyy-mm-dd Can someone show a use case for this?
-
Dataset Scheduler - Timezone list limit and/or alphabetic sort
As a new customer setting up datasets, the time zone selector is just a poor UX. First off, the time zones aren't sorted any logical way. It would be nice if they were at least alphabetic. Type to search would be helpful. But my primary "idea" is to add functionality at the Admin level to limit the time zone selectors to a…
-
Date range selector
Hi, How do I change the min and max value date format ie. 01/21/19 to 21/01/19
-
Webform Row Highlighting
When updating larger webforms, it would be super helpful for the the row number (on the far left of the screen) to highlight when you click on a row. If you're on an ultrawide monitor and have a number of columns, you can easily lose where you are and accidentally put data on the wrong row. It could be helpful for the…