-
Pivot Table - add ability to group columns by values and then dates
In an excel pivot table that includes multiple value fields with a date field as the columns, you can move the "values" field above the "Date" cell in the columns section to group the columns first by metric, and then by date. In Domo, adding two metrics to the "values" section only allows for plotting by date with each…
-
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…
-
Allow Ability to Show Alternating Row Colors in Pivot Tables
Please add the Chart Property "Show Alternating Row Colors" in Pivot Tables. Currently, you can only use this option in the regular Mega Table and HTML Tables. It helps to make tables easier to read if you can show that definition between the rows.
-
Got a fun one for grouping Columns together. Need help building
This one will take some setup. I have a card by Style and Color, with values of Total AVAIL STK and then broken out by Size columns, and TOTAL WIP and by Size columns. The issue is when we filter to a style, we don't need to see the sizes it doesn't have. If we're viewing a purse, it only needs to show "1SZ" since it would…
-
Default to 0 decimal for numeric/currency
I change this default literally every time I add a field to a table and elsewhere in Domo. It's extra clicks each time (per field added to a table). Additionally, when other users create their own reports they rarely change the default behavior and it remains at two decimals, which reduces data comprehension. For example,…
-
Combining Filtered Rows to one table
Hello, I am using one dataset for all three cards shown below. I have them on separate cards right now as they each are filtered to different things. Is there a way I can combine them so they would all show on one card/table together with one heading but show the three rows one under another with their filters still…
-
Calculating YTD for each week in table
Hi, I want to replicate a table that looks like this: My dataset currently has date, impressions, and goal, and in ETL I've mapped the dates to a week by joining with another table. How would I use beast mode to find the impressions to date for each week, as well as the delivery percentage of goal?
-
Table Column Display Type Link - Open in New Tab
I find myself not using the new feature to display a text column in a table as a link because it opens in the same tab. It would be nice if the default of this new feature was to open in a new tab, since I don't know anybody that would want to open it in the same tab anyway. Alternatively, you could add an option to open…
-
Discrepancy in Row Count Between Two Tables
Hi, I created two Mega Tables with the exact same filters, but they are returning different row counts. The first table shows only 8 rows, while the second table returns 28 rows. The only difference initially was that the first table was originally an HTML table, and one of its columns was based on a Beast Mode…
-
Allow table cards to control more than one filter at a time.
The idea for this post comes from DOMO support # 05895045 When you click on any card to create a page filter, the card becomes the 'controller' for that filter. Currently DOMO only supports table cards that control one filter at a time. The original issue we observed was with pivot tables removing all filters when we tried…
-
Revert Sort Icons Update in Card Analyzer
Anyone else hate the new sort icons in analyzer? When Domo updated their icons last month across the platform, they deployed these new sorting icons in analyzer: To me, these icons make no sense. First, ascending means larger data as you go down, so the icon having smaller lines as it goes down is opposite, and vice versa…
-
Bullet chart
I am trying to show the target in the bullet chart by region As you can see the data is populated correctly but for some reason that I couldn't figure out the chart value with the target is super high so I can not see the actual data in the chart
-
How do we hide/merge duplicate cells in a column in HTML table
Hi Domo team and users, I am using an HTML table for my card, because I need to implement some cell specific conditional formatting (not shown in this screenshot) and only HTML Card works out for this. But while using this visual, there is no option to consolidate the repeating vales in a column. Any insights on this is…
-
How to get Prior Year Values on the same table row
I’m trying to create a row which shows the “Prior Year” value against a field for comparison, simply a 12 month offset of the data as shown below with the "Value" field. This would later enable me to create YoY differences. I will also note that I'm looking for a solution that should be able to transcend filters i.e. you…
-
Heatmap for Pivot Tables
Is there no heatmap options available for a pivot table? Is there a workaround? Its already present for the normal tables.
-
Table cards: Expand/Collapse on Multiple Columns
Currently, I can get a single level of expand/collapse functionality on the first column of a table if I add subtotals. I would like to be able to add the expand/collapse button to any columns.
-
Correctly show financial information: Show positive sign on Expenses, COGS, Other Expenses.
As a financial dashboard, currently the way that domo display the P&L is incorrect. In the P&L, the table follows the formula: Total Net Income = Income - Cost of Goods Sold - Expenses + Other Income - Other Expenses in the card. However, all the COGS, Expenses and Other Expenses are showing the negative signs which…
-
Allow ONLY HEADER text to wrap in table card
Please give us a chart property for mega tables to allow ONLY HEADER TEXT to wrap. Allowing the whole thing to wrap can cause uneven sized rows, which is really hard to read. But, a longer header can cause a wider-than-needed column. I've played with setting the column sizes via chart properties, but that can cause headers…
-
"Add All Columns" button for Mega Table Charts
When looking at data in a mega table chart, I find myself frequently going through the list of dimension and measure columns and adding each individual column, one-by-one. I suggest adding a "Add All Fields" button to bring in all Dimension and Measures Fields in the DataSet - See Picture Example 1. Alternatively, add…
-
Icon Library for Table/Pivot Cards
Currently, html is required in order to display icons dynamically based on a range in a table card. It would be great if there was instead an icon library available in table cards (and pivot tables) where icons could be selected from the library and then assigned to a range through the configuration properties of the…
-
Table card column borders and padding/empty columns for visual enhancement
In excel, financial statements and schedules often include empty columns to visually separate or group together columns showing different metrics. It would be great if Domo had the ability to insert padded columns in the same way. Currently when you have a table card that displays multiple metrics and variances, it all…
-
Variance % formula not working correctly at Grand Total
What I am trying to do is look at Monthly Headcount Trend (Variance %) by Billable, Non-Billable and Total. My approach to identify change % is : (Current Month - Previous Month) / Previous Month. Since, it will be showing multiple months data in a tabular form, so I used the following formula for Variance % (SUM( CASE…
-
Number Abbreviation Options
Can we please have the option to fix the number abbreviation at a certain level, i.e., have all numbers always displayed in K, M, or B? Currently the abbreviations are automatically determined, but dashboard users have found it confusing to mix the units of measures in the same table.
-
Adjust Column Widths in Pivot Tables
Currently, you can set column widths under "General" properties of a regular table, but not a pivot table. This doesn't allow us to maximize space on the page.
-
Mega/HTML Table Border Options
Options to select and customize border attributes to highlight different sub-groups in your data table (please refer to the attached image). I tried to do this via the subtotals option but this is dependent on the first column. However, for readability I need to have the first column as Customer Name and the table sorted…
-
Beast Mode Calculation used to view data in Table
My question is related to showing Comments/ Verbatim in a Table using a Beast Mode to Apply Business Rule. In Org Survey, we want to make sure that if we have less than 5 unique comments then don't show the comments. If the Business Rule of >= 5 comment is met, only then show the comments/verbatim. Below is an example…
-
Filtering Question
I have a mega table report that is displaying customer invoice data. One of my filters is for the Aging Range. I have been asked to modify the filter to include all invoices for a customer if any of their invoices are in the filtered range. Meaning that in the below dataset if they selected to filter 151-180 all invoices…
-
Pivot Table switch values to show as columns or rows
Been working with Pivot tables for a while now, and one of the huge things I miss is the ability of selecting whether the values should be displayed as Columns vs Rows, something that you have in simple spreadsheet programs. This has proven useful when you want to show the same metric by different aggregations for example,…
-
Conditional Formatting - table MoM
Hello, I'm trying to set color rules/conditional formatting in a table card. What I'd like to do is set rules that if that months sales figure is higher than the previous it'll be green, if that months sales figures is lower than the previous it'll be red. (ex. If July sold 10, but Aug sold 8 August's value would show as…
-
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…