-
Ability to Suppress Duplicate Value Headings
In the pivot table card type, there should be a way to surpress the value column heading if there is only one value being presented in the table. This can appear very messy.
-
Is it possible to create a table showing appointment availability in Domo?
I have a list of appointments scheduled with their start and end times, I've created a pivot table showing all appointment start times as the row and closers are broken out into columns. Through an ETL, i'm able to count the number of appointments scheduled at that start time but what I'd really like to do is mark off each…
-
Can you include video in an HTML table?
Hi there, I have created an HTML table card that displays images (not links to the images but the actual images themselves). I've used a case statement because the dashboard the HTML table card is on gets filtered by category. Here is the generalized beast mode I made to display the images: CASE WHEN 'Category' = 'C1' THEN…
-
Image Hosting
End Goal: I want to display a sales rep's headshot next to their stats on some "Top 5 Producers" style cards. I'm familiar with the HTML code to do this, and I know I can put these pictures on a free online image hosting service to do it. But my IT department would probably "expel a kitten" over this because they treat…
-
Any way to get text value from one column based on text value of another column?
I've got a data set that is a series of user and assistant responses. I'm trying to build a table visualization that will show me all user questions where the assistant did not have an answer. My thought was that I could search for the default “no answer” response in the assistant response columns, but am stuck at how to…
-
Tooltips for Tables
Tooltips for tables would be useful for both adding context and saving space. For example, by hovering over a cell, it would be great to see the data point expanded:
-
Is there a way to force a column header to be blank?
When formatting a column "Data Label" in a table chart from the formatting drop down where you would format justification etc. - you are able to override the column name with more plain english. However, in some instances, I've wanted to override the column name with nothing, i.e. have a blank column header, especially if…
-
Pivot Table - restrict collapse/uncollapse for end user
Hi, I have a business need where I am using a pivot table to display rows of financial data which mimics a Profit and Loss report. Each subtotal section is a copy of data with dimensions. This is working well and giving the desired results. Except for the report rows which are subtotals where I would not want the row to be…
-
How to Include Subtotal Percent in Pivot Table?
When in the analyzer, I selected a pivot table Next, Chart Properties --> Subtotals --> check the box for "Show Subtotal Rows" This gives me the subtotal for each subcategory. Is there a way I can also show the percent total for each subcategory?
-
Roll up rows in table chart with similar fields
I have a dataset of brands and corresponding data. I would like to have any rows with the same ID and device to be summed up and in one row. I don't want to use ETL for this because there is another column that distinguishes these rows so they may need to be filtered separately at times. Thanks
-
Increasing m x n dimension of a pivot table
I was trying to build a pivot table where columns would be month names, but DOMO can't handle pivot tables with (m+n) greater than 10. (m- rows, n - columns) It would be very helpful if you increased a possible number of dimensions of a pivot table.
-
Can we add back button in domo dashboard?
I have two dashboard. I have added hyperlink in table data in one dashboard which is navigate to second dashboard with pfilter. It is working properly but once I navigate to second dashboard then I am not able to back first dashboard. I need to refresh the whole page. Can anyone have idea about it? How can I navigate to…
-
Beastmode for multiple row comparisons to one source row?
I'd like to add a third column in a table visualization that displays the % change for the current week to each previous period listed. What's the best way to create a beast mode for this?
-
How to hyperlink values in a Mega Table
I have a dataset I am showing in a Mega Table, which contains URLs. I'd like to hyperlink the URLs so the user can click on them and go to the site. Is there a way to do this? I've been trying to following this suggestion:…
-
How to compare Value Columns
Hi, Beginner to DOMO so excuse the question. I've created a Pivot table with 2022 sales vs 2023 preorder sales by account and would like to add in a % difference column at the end that shows whether an account is up or down for 2023. How do i go about adding that?
-
Table Cards - clicking and drilling on selected columns/rows gives wrong drill filter
Any time I use a Table Card in a drill layer (and even top level i spose) - the user can click on any of the data in the rows. For example, I may have a column that does a count Count of service requests. on a table chart that lists all properties and their respective service request counts When the user clicks on that…
-
PLEASE stop tables from auto-expanding when new items are added
It's messy, frustrating, and it makes us look like we're not maintaining these cards or pages properly. It's also difficult for end users to use when we have large tables, as they have to collapse every item (every time) they use it. If it's saved with certain columns collapsed, it really needs to stay that way. A…
-
Domo Governance - Chart Types
It would be helpful to see the Chart Type in our Governance Datasets. Right now I think we can just see if it is a Textbox or a Chart. It would be very valuable to be able to tag if it is a Table Card. I would like to add dynamic glossaries at the top of each dashboard to have hyperlinks to each table card on the page for…
-
"The Pivot Table is Only Showing Part of the Data" Error
In our KPI cards using pivot tables, I keep getting the following error. ”This pivot table is only showing part of the data. The visible rows and/or columns are incomplete.” There doesn't seem to be anything wrong with the DataSet, and I have not been able to identify the cause. Has anyone else had a similar error?
-
Issue in creating pivot table
-
How do I get my subtotal and total rows in Table card to show the avg of % rather than the sum of %?
For the column of my table that's using percentages, I'm getting these percentages through a beast mode: count(`Opportunity.CreatedDate`) / (case when `Team Months Active` <= 1 then 40 when `Team Months Active` = 2 then 80 when `Team Months Active` = 3 then 120 else 160 end) For some reason, the Total and Subtotal rows of…
-
Calculating percentage corresponding to blank cells
Hi all, I want to calculate percentage of the events count in my dataset like below Here, we can say for the month of August, there are 67 events with flag=true. Hence, we can see 100% displayed next to it. Similarly, for the month of September, there are 3 Outcome2 events with flag=true. And the percentage comes out to be…
-
Filling blank cells with 0
Hi Team, I've recently started domo to build reports and I'm trying to fill 0 in below blank cells in one of my reports. The thing is, in my dataset there's no data for August month for the highlighted rows. I believe that's why I see blank in Domo. Till here it's fine. Now, I'm trying to display 0 in these blank cells.…
-
Is there a way to create a static temp table in Beast Modes?
I'm the MajorDomo for a large retailer, and our Fiscal Calendar uses a 4-4-5 format. This means we have a Week 53 this year, and a large portion of our Domo reports are built off of a TY/LY comparison. I'm working on logic to reconfigure our reports always look 364 days or 52 weeks ago, rather than look at the same Fiscal…
-
Ignore Row Context / Power BI 'ALL()' Equivalent?
I mocked up a simple example to illustrate what I'm trying to accomplish. The question is: how to create a beast mode which will ignore any filters and/or table row context applied to a column, in this case `Store`. The goal is: calculate Average Order Value for the entire dataset (Total Company), so individual Stores can…
-
Attempting to create unique rows for each possible value in a chosen column
Our business model currently offers multiple product options. I'd like to create brand new rows for each customer, 1 for each product, whether they own that product or not. My thought is to use new columns and then use a dynamic unpivot. Need help creating the new columns first though.. Currently have this: Account Product…
-
Only show unique values of a column in table
Is there a way, in analyzer or ETL, where we can only display one row for each unique value of a column corresponding to a key column? For example, I would want this: ID Num 1 4 1 4 1 5 2 4 2 5 2 6 3 6 3 7 3 7 to become this: ID Num 1 4 1 5 2 4 2 5 2 6 3 6 3 7
-
Error filtering Data
Hi, I'm using a filter on a Dataset I which I need that a column A to be different to FALSE and another column, B, equals to FALSE, but it is not doing the filter correctly