-
More options for color rules for cards
When establishing color rules on cards, you're limited to selecting a single column and the criteria which for text fields is only either IN or NOT IN. While this is useful for most cards, it's really limiting when you have Pivot table or cards that are grouped and stacked on different dimensions. In the case of Pivot…
-
Is there a better way to play with Table Totals/subtotals?
Hi domo community, question. I'm having hard time getting my totals to look the way I want to look on a table, the perfect collapsed view would be If add and extra column and hide totals/subtotals and suppress ingle items in subtotals looks ok on expanded view (Image 1.1), But if I collapse it looks like image 1.2 Let me…
-
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.
-
Table card subtotals - allow blank labels
I often use subtotals in mega tables/pivot tables to group child rows together, regardless if I'm aggregating totals or not. I've found that being able to suppress the subtotal label text (e.g., "TOTAL") would make the tables look much cleaner. I don't see a way to complete omit the label so I usually put some small…
-
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…
-
Color Coding or conditional formatting in DOMO?
I am trying to make a scorecard for budget…etc… Let's say our budget in Jan was $14,418,053 and are actuals were below that. How could I turn that budget red? and vice versa if actuals were above budget it would be green? Is this possible in DOMO yet or are there work arounds. Thanks, Garrett
-
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…
-
Dynamic Column Names in Tables
The introduction of variables allows you to create much more dynamic table cards where the user can pick and choose which columns he/she wants to see inside the Table/Pivot Card. However, Variables only changes the data that shows up inside the table, it currently can not affect the Column Name so i have to end up naming…
-
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…
-
Why is my beastmode to bring in Salesforce Profile Photos not working?
I'm using the html code referenced in this Domo Article: Our salesforce rep profile photos are being brought in as a url starting with "https" into a user dataset. I'm just not understanding what is wrong with the beastmode that it's not bring up the photo when I place the beastmode as a column on a table: CONCAT('<img…
-
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.