-
Drill path for tables
Hello! :) I need to use drill path for a table (card) in DOMO such that when you click on one cell of the table, it goes to another table related to that cell. Could you please guide me in this regard? Thank you!
-
Interactive Tables with Writeback functionality
Hi There, This may be a complex ask. But I think it could be extremely valuable. I would love to create a table powered by Domo for our planning team that is powered by Domo but would also have a dynamic user input field. This field would adjust calculations on the card but could also have writeback functionality. In my…
-
Search results to show unique values
Hello, My backend data in excel has over 50,000 rows and one of the column is #ID shown in the below screenshot. I am searching for an existing ID "9996", but it just shows the 3 values. And I see the note below the search bar which is confusing, and not sure how to filter the page to see all matching unique values. Please…
-
Advanced Donut Chart with multiple rings
The donut charts in Domo appear to be quite limited. I created my own code to display a multi-ring donut chart, using a Domo blank brick. Generic screenshot below. Each ring in my code has an actual amount, projected amount, and budget amount. The light gray represents the projected. The darker gray represents the…
-
Mega Table SubTotals in Brick
I am lost in how subtotals are integrated into a mega table in a brick. I started with the ten data source DDX brick, and I was comfortable with configuring the options and the two data queries; however, the subtotal has me stumped. Is the subtotal a third query or somehow handled with the data from the original query? I…
-
We need a tile that alphabetizes columns in Magic ETL
Can we have a tile in Magic ETL that alphabetizes columns? Right now, I have to manually drag columns to get them ordered correctly for the next step in the ETL.
-
Can we get different color badges based on different certification paths?
Right now, all my certified cards look the same. I have to hover over the certification to see which department certified the card. It would be cool if I could have a purple badge for "Loan Officer Certified" and an orange bade for "Accounting Certified", etc.
-
Sub-Category of a Category?
Hi All, We are working on a report that has a few different program_namesthat are summed up in a pie chart using orig_loan_amount. I have been tasked with trying to sub categorize our bonds using a taxable/tax-exempt designation The problem I am trying to overcome is that our bonds (identified by pool_name) are actually…
-
Filtering a card
I am trying to filter off certain Key words for a column- But when I go to add several key words domo does not calculate properly.. is there any way to filter off multiple key words? The issue is these key words arent always at the start of the description so i dont think a beast mode would work. Let me know if I am wrong!
-
Onedrive files failing
Hello, we noticed a couple of weeks ago that a bunch of sharepoint/onedrive files that we have set up to ingest into Domo on a regular cadence, are failing. The error message in Domo is the same for all of them: "Domo is ready, but the requested file does not exist" We haven't moved the location of any of these files, so…
-
Filter Cards Not Showing All Data
Hello, I have been trying to create dropdown filter cards to get around the fact that you can't organize the filter views on a dashboard after they have been created. I have two cards that allow the user to select the company/location of the data that they want to see. However, the card is not displaying all locations that…
-
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…