-
Pivot Table - More control over subtotal rows
It would be a useful enhancement if you could select which rows showed subtotals in a pivot table. Right now, it is all or nothing. This can make for a busy, and not very helpful look, if there are several fields in the rows section. Would be nice if you could select if you just want to show subtotals for the first row and…
-
Issue with Sales Data Tracking and Date Transformation
Hello, I'm encountering an issue with tracking sales data in from our CRM. The problem arises from the fact that the table card relies on the 'Date Created' column for capturing engagements. Although this successfully captures most sales data, it fails to include engagements that were created in the previous year but…
-
Column created with Beast mode with numeric and porcentage format
.Dear community, this month I have receipt separately two cases with the same concern: The users have shown to me functions created with beast mode, inside a pivot table card. The goal is set in the same column figure with number format and percentage, including the symbol “%”. I have attempted so many ways, but I don´t…
-
Pivot Table - Use of Beast mode in the rows
Sharing the feedback on behalf of the customer from Learn IT Systems, he suggests that the Pivot table card should allow the use the of Beast modes having Windows function/ Aggregation in the rows section of the card. Presently it does lead to errors in Subtotal/Total while using such beast modes.
-
Customize Color Theme / Reverse Order
I recently built a heatmap table where I want the lowest numbers up top. These start around -25 and end at -10 currently, but the numbers will change each time the chart is updated. I also only want to show 10 rows of data, so the table has been limited to the 10 top results. I want the heatmap to display negative numbers…
-
Pivot table show only certain value under specific column
Hi, I have a pivot table with different media types as columns, and 2 types of values, instances and revenue. I only want to show sum of revenue under TV media type, and only sum of instances under Internet media type. Is this possible with one chart?
-
Pivot Table Sorting
I have a card that shows total sales by sales rep (count and volume) for the previous quarter. I'm trying to sort top down by count, then volume for the previous quarter but I keep running into issues. When I add the date field (so the oldest month appears on the left) I can't get the totals to sort properly either by…
-
Color code table columns based on tags
Our privacy officer wants us to start tagging table columns that contain PII. The problem with that is that when you add a tag to a column the only visual indication a tag exists is the information icon (a lower case "i" in a circle). We would like to: a) assign colors to tags so that when they do display the color is…
-
Filter metric by Beast mode dimensions
I have a Beast mode that configures source and medium dimensions into broad categories because Google's default channel grouping dimension is incomplete. (CASE WHEN Session Medium LIKE 'cpc' THEN 'Search' WHEN Session Medium LIKE 'paidsocial' THEN 'Social' WHEN Session Source LIKE 'google' OR Session Source LIKE 'bing' OR…
-
Can I use a filter to make a filter?
I have a dataset that is a schedule of products to promote. A different product is promoted every day and we don't want to promote the same product more than once per month, at least. I want to be able to look at my schedule (just a table in Domo) and only see products that I have not promoted over the last 4 weeks, 5…
-
Show average, count, and sum when selecting table card cells
When viewing a table card, it would be awesome to be able to select numerical fields and see a quick aggregation summary, similar to what Excel does below:
-
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:
-
Workaround to Pivot tables pushing non-valued categories to the bottom.
Hi, I'm currently trying to build out a pivot table with custom sorts on both the row and column values. As has been mentioned before on the dojo; pivot tables will always override the sort so that non-values will display last even with a custom sort including the column/row headers. Has anyone found a workaround to this…
-
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…