-
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.
-
Have a row displayed with 0/NULL when filtering by date when there's no data
Tried my best to summarize in the question... I have a data set of Google Adwords Data. I'm putting the data into a Pivot table and have campaigns as a Row. I'd like to have every campaign show in the table even when it has no data to report for the selected time frame. It essentially would the the row for the campaign and…
-
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…