-
Provider Prior to Upgrade
I am trying to determine who provided the evaluation prior to an upgraded premium procedure. I have all the data I could ever need, but I'm not sure of the logic to make it happen. The task is made more difficult because there could be multiple evaluations prior to a procedure, and evaluations on different dates than the…
-
Mega Table Rank interactions with PDP
Hi all, I am trying to build out a dashboard that lets vendors compete with each other in a mostly anonymous way. One example would be a section that shows the logged in vendor their 7 Day Sales Rank, compared to their 28 and 91 Day Sales Rank. Key requirements: Vendors should be able to see their rank only; not any of the…
-
SMART or FORMULA BASED NAMING AND COLOR
2 ideas here… SMART TEXT OR FORMULA BASED (CONDITION BASED) NAMING This would be for columns or labels on charts. Instead of saying This year… it could say 2025 for example and change dynamically as the years change instead of having to manually change them in the system. FOR COLOR RULES: I would suggest having more…
-
Drill Down while maintaining breadth
I want to be able to interact with a card wherein the scope of the x-axis (time in this case) is sticky, but the series changes. Right now, if you drill down to a point on the x-axis, such as a year, it drills down to the year. Is it possible to drill "across" to a separate series? I understand that the Drill Down isn't…
-
Pivot table values on row or column
I didn't see any posts about this in the Analyzer Ideas section, so if there is already a post out there, I will upvote that if someone can send me the link. Anyway, pivot tables should have the same functionality as Excel where you can move the values to either rows or columns. The current solution is to create yet…
-
How to shift first week of year from December to January?
The card pictured below is filtered to 2025 - however, Domo's default week starts the prior Sunday which still lands in the month of December. I would like it to show a January date instead for the first week of 2025. I would ideally not like to use week numbers over actual dates on the x-axis. Has anyone else experienced…
-
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.
-
Edit Annotations
I would benefit from the ability to edit annotations. Currently the only option is to delete an annotation and create a new one.
-
Show a warning when editing a card that is on multiple pages/apps/etc.
Just as there is a warning when editing dashboards that are embedded externally, there should be a warning when editing cards that appear on multiple dashboards. Ideally it would say "You are editing a card that exists across x pages" then the x is a link you can hover and a popup there would show all the pages it is on. I…
-
Best Practice - Columns to Rows?
Community, My data is formatted per my example screenshot below. Is it best to pivot each location into rows, or is there a benefit to maintaining columns for rows? I will need a total number, and then drill down numbers (I.e. Total Net Profit = 30 > Drill Down > Omaha Net Profit = 10)
-
Create Bar Chart with Current Month Vs Previous Month?
I have a data set of invoices that I want to compare in a bar graph where one bar is October and the other bar is November. I suppose I can do this with a beast mode but I think my syntax is off. Case when Title LIKE '%OTT%' Then 'OTT' AND MONTH(Date) = CURRENT_DATE(MONTH(Date)) THEN 'Current Month' Case when Title LIKE…
-
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,…
-
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…