-
Filtering on missing / null values is awful - improve it!
TLDR: If a column contains a null value, there is no way built into the UI to filter to select null values only. Additionally, if you happen to choose "NOT IN" as your filter type and select a value, NULL values will additionally be excluded even if not requested. I understand that there is a workaround using beastmodes,…
-
Apply color rules based on one column's values to other columns
There are so many use cases where this would be applicable. I am seeing a number of other discussions about this, but not any that are actually in the Idea Exchange. So I am posting it here just in case. If it already exists, someone please let me know and I will upvote that one.
-
Group Total - Aggregated Series
Community, Is it possible to have a drill down that retains the prior level's aggregated top-level value? I.e. I want to be able to drill down from an overview, into a series specific break out (And here's the kicker) while maintaining an additional series that displays the group total from the prior drill down. For…
-
Option to display date range field name from Card Details page
One of the most common issues I encounter when troubleshooting cards is that the date range is based off of the wrong date field. Currently it's too easy to not notice which date field is being used since users cannot see the date field unless they specifically open the date range settings in Analyzer. It would be helpful…
-
Gradient colors needs a midpoint setting
The recent gradient color addition to Analyzer has the potential to eliminate the need for setting up a bunch of color rules for variance colors, but it needs the ability to set a midpoint value like the heatmap color setting on table cards. Currently the gradient colors are relative to the bars displayed on a chart…
-
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…
-
suggestion: add number of samples in boxplot
hello all I am creating cards with boxplot and I would like to add in the label the number of samples observed in each box, but that option is not available. The ultimate goal is to give final users a hint on the box being statistically relevant or not. Other alternatives could be to modify the color or the width of the…
-
Bar Chart set to show last 12 months, is only showing 11 months of data as the first value is zero.
I have a Bar Chart with the last FY worth of data up to 30 June 2021. I'd like the chart to show the last 12 months of data, however, it is only showing the last 11. There is no data in July 2020, which is why I'm guessing it's not showing the column. The nature of the data is that there will be no entries if there were no…
-
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.
-
Ability to override Colour Source colours on Filled Gauge cards
For this particular example, I'm using a filled gauge which has the ability to automatically change the colour based on the target value by selecting either "Green Above Target" or "Green Below Target" resulting in the below red or green. The problem with this is that the specific green and red that the card uses is locked…
-
Be able to change the default color of positive and negative values in charts
Hi Community, We'd like to request the capability of changing/defining the default positive and negative color in "Change value options" in charts like "Multi-value". Currently, the default color for positive value is green and it's red for negative value. However, we'd like to avoid using red and green for potential user…
-
Dropdown Selector: always have pre-selected the latest date on a filter card.
Hi, I have a filter card (dropdown selector) to display all dates available and I would like to have pre-selected the latest date. Is this possible? Right now I added it by manually typing the latest month but I'd like it to switch automatically when the month ends. Any ideas are welcome! Thanks
-
Put Legends back how they use to be
I noticed legend titles appear at the top of cards now instead of directly above the legend. I put in a ticket and support told me this is "expected behavior". I guess at some point Domo made another silent update without telling anyone. Please put the legends back how they used to be, seems very weird to have titles…
-
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…
-
Calculating percentage in beast mode based on count
Hi, I have a dataset that looks like this: Network Hour Date Avails A 1 1/1 2 A 2 1/2 4 B 1 1/1 6 B 2 1/2 8 C 1 1/1 10 C 2 1/2 12 C 2 1/2 12 The number of avails is the same for every row that has the same network, hour, and date. I need to write a beast mode that calculates the number of different rows that have the same…
-
Gantt chart extra spacing
Anyone know if it is possible to get rid of this spacing at the top of each series on gantt charts (highlighted in light purple)? It is only at the top of each section but not the bottom.
-
Color Formatting on Directionality
Hi Community, Thanks in advance for your help! I'm trying to highlight directionality of referrer's volumes. I want to compare to each referrer's prior month, not to a total or to an absolute value. For example, we can see that Jacob dropped off in April. We can see that Bob and Smith are trending upwards. These insights…
-
Complimentary Text Color for Data Labels for Line Bar Chart
I have always use Complimentary text color for data labels in my chart as it makes the labels much easier to read. This is where I would normally go to set it: However for unexplained reasons (the Domo Support team mentioned that this is by design) I am not able to set the same for a Line + Bar Chart type, see below where…
-
How can I avoid denominator should not get filtered while calculating the percentage in beast mode
Hi, I have a column name 'Order' with 1 to 6 values in it. I need to calculate the percentage of order 1 and show this percentage on a card in the dashboard. This percentage should change dynamically when the data gets refreshed. I am taking unique count of orders having 1 divide by total count of orders. when i am…
-
Is it possible to change the default chart type in Analyzer?
I almost never use the default bar chart in any case. So it's fairly annoying to open Analyzer, have to change the chart type and remove the randomly selected default columns. Especially if there is a large amount of data to be rendered. If it's not a option currently I think some settings should be added to allow for…
-
Change Default Chart Type and other default settings in Analyzer
I suggest an option be added to change the default chart type and column values for Analyzer. I almost never use the default bar chart in any case. So it's fairly annoying to open Analyzer, have to change the chart type and remove the randomly selected default columns. Especially if there is a large amount of data to be…
-
Dynamic Conditional Formatting
Current conditional formatting is very useful, however still quite limited in functionality especially with numeric and date values as these are static. A current workaround for this is to utilise HTML tables, or create additional columns for above/below the required targets, which gets quite messy. It would be hugely…
-
Pivot table enhancements
I would like for the ability to choose whether Pivot Tables expand/retract vertically rather than horizontally. Right now, each level is stored in it's own column. This often takes up a ton of unnecessary screen real estate. I'm envisioning something more like this… VS how pivot tables currently function
-
Compare to Industry Trends
Hi community, What's the best way to compare two different series when they are on totally different scales? My hope is to see if our trends compare to industry average. I've got month, year, our total, and the industry comparable. For instance: Date My Company Industry Jan-24 100 50000 24-Feb 150 60000 24-Mar 175 70000 I…
-
PRODUCT RELEASE SNEAK: Analyzer Updates
As an active Community member perk, we will be providing insider sneak peeks for the Analyzer features we will be releasing on Monday July 22nd 🥳 Analyzer is where your data visualizations come to life. We understand the value of quickly taking your data and translating it into an easily digestible visual. So, we’ve…
-
Allow Beast Mode as "Default Value" in an Input + Slider Variable
Hey guys! I think it would be really awesome if you allowed Beast Modes and/or Aggregations as the Default Value in the Input + Slider and Slider Variable Type (see screenshot). I heavily use variables to show how changing Win Rates up or down by X% would influence our End of Quarter Net Revenue Projections, and I think it…