-
Custom Date & Timestamp Formatting in Analyzer View of Cards
Hello Domo users! As a relative newcomer to this fantastic platform, I am thrilled to share my first discussion post with the greater Domo Community. I've been working with Domo for nearly a year at this point, and it has been a wonderful experience and I truly admire the insightful analytics and operational abilities this…
-
How to aggregate a case statement that uses a fixed function
Hello, I was hoping somebody could help me understand how to sum the following case statement. case when `Date` = max(max(`Date`)) fixed () then `On Hand by Day - DO NOT SUM` else 0 end I need the calculation to be dynamic and reference the date selected on the card. All attempts to aggregate the case statement fail and…
-
Color rules for Multi-value cards
Our company is currently using several multi-value cards to show summary numbers compared to goals. The multi value cards do not allow for creating color rules for when a value is = the goal value. The only option is to reverse a color rule, which then has to be changed back once the value is above or below target again.
-
Dataset Color Rules - lock color to column regardless of rules
Much of my data compares KPIs across 30+ different cities. When I use city on series, the colors are assigned in the order they are charted. So if I'm charting A-Z, the first in the alphabet gets for instance light blue. If, on another KPI, the default sort is by value high to low, the colors are completely mixed up.…
-
Reverse Color Direction to Heatmap features in table
Our use case require to show lowest numbers in darker red color. I'm able to hack this by using diverging and setting the midpoint to an unreasonably high number. Nonetheless, it would be great if there was a toggle just to flip the color direction.
-
Average Nested Bar
Good day everyone. I was trying to build a nested bar, but wanted the gray at the back to be determined by whatever aggregation we use for the calculation. So for example in the following graph, rather than showing me the bar in the back as the SUM of all the individual bars, it'd show it as the actual average of the…
-
Color Rules: Prevent table card from inheriting colors
If I set a color rule on a bar chart, and build a table card as the drill, I cannot remove the color rules from the table. The color is inherited from the bar chart, and the only change I can make is to uncolor the WHOLE table row, but I can't simply remove color in the first place. In my use case, the only reason to have…
-
Column level color rules based on multiple statements
I have a pivot table that it would be super helpful if I could color code columns based on multiple statements using the color rules. I know there is a work-around using HTML, but this would make it much simpler. For example, I want the cost per acquisition number to be green if below $20, and red if above. However, it's…
-
Adding Links to Card Descriptions (Rich Text Editor)
Currently, card descriptions only support basic text and smart text. It would be incredibly useful to be able to put rich text links inside of a card description. These could be links to other items in Domo or to external sites. I imagine this working very similar to how notebook cards currently handle adding rich text…
-
Dynamic Currency Symbol Formatting
Currently in Analyzer, number columns can be formatted as currency, allowing you to append one of 4 currency symbols to the beginning of the number in the chart. It would be incredibly useful to add a dynamic currency column option. Rather than having to select 1 currency symbol for the whole column, you could select…
-
Issues with Average Function
I have detailed biweekly pay data where I am looking for the average hours worked in every region per week (using a basic calculated field). This functioned well for 6 months but became an issue at the start of the year. Rather than finding my typical averages, suddenly the data is showing me trillions of hours in every…
-
How to calculate a percentage based on another beastmode
Hi I am trying to calculate a percentage of customers who repeated, out of all customers. Basically count(distinct repeat customers) / count(distinct all customers). This has to be done in beastmode so users can select a date and the repeat customer % will be dynamic. This is the raw data, Cumulative sessions is used to…
-
Y Axis on Horizontal Bar - Allow Long Labels by Default
I was thrilled to discover the "Allow Long Labels" checkbox on the horizontal bar chart - however, I only think to go into Analyzer and apply it when I realize my labels are cut off in the first place. I would love to have Long Labels allowed by default, and we can uncheck to shorten to the ellipses version of labels Can…
-
Card Title and Description Text Formatting Options
Currently there are no options to format Cart Title and Description text. Potential use-cases for text formatting include: (1) to call attention to Smart Text values (2) to use title text as chart color legends (ex. see the "1. integrated text" example on this page:) Desired formatting options are to be able to use Bold,…
-
Compare values in a series against overall average
Hi Domo community, I'm looking to create a card that shows which segments are bringing our Net Promoter Score (NPS) up or down. My idea for a visualization is below. The centre line is the monthly overall NPS and then the 4 bars (International, United States, Canada, and regional) are the series that show the different…
-
Is there a way we can merge the columns in DOMO table card?
I want to merge these column name in table card. Is there any way we can do this?
-
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…
-
Tab Autocomplete Messed Up
For years when pressing tab on the keyboard when in a DOMO code editor it has functioned like an auto complete or a tab space entry, however recently this functionality has broken. Tab no longer autocompletes nor does it allow to add quick spacing for code readability. Instead, it moves to the next element in the beastmode…
-
Create Bar Chart with Current Month Vs Previous Month?
Hello, I have a data set of invoices that I want to compare in a bar graph where one bar is March and the other bar is Feb. I think 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…
-
Save As in Locked Cards
I would like to lock pages and cards so that only a users assigned to a group that owns the card or page (or is an admin) can edit them, but want all users with a user role that allows them to edit cards to be able to duplicate (save as) the card to their own overviews so that they can manipulate them.
-
How would I filter for Order Numbers that contain UN codes? While keeping all other part numbers
Hi all, I am trying to figure out how to do this in Analyzer via Beastmode or filter tool. I am trying to only filter/display Orders that contain a product with a UN battery code while still displaying all other items in that Order Number. I'm having a tough time finding a function that could do this. Any ideas? Thanks in…
-
Looking to create a benchmarking bar chart showing +/- % from prior year
I am wanting to create a bar chart similar to below. I want the +/- % to be based on prior year CPM. I am not seeing a bar chart that would operate similarly to this - does anything have any experience with this? Thanks
-
Is there a way to "freeze" data in domo to compare net new information to previous information?
For example: I have Promo X that has been running from Jan – Dec 2023 and I can see the impressions for that time frame with no problem by filtering to that date range and looking at the data for that date range. | I’m now running Promo X in March 2024, and want to look at net new impressions to this promo in March 2024…
-
Clear all fields option in Analyser
Could we have an option to clear all fields in Analyser? Whenever a new card is created Domo 'guesses' which fields to include, this is never what we want so a quick way to remove all measures and dimensions would be a big help. Alternatively an option to diable the automatic population of data into the worspace would…
-
Early noob questions and frustrations around filters in analyzer
I'm experimenting with Domo and I'm trying to recreate some powerBi reports. I have successfully connected to our Jira instance for issues and I'm now trying to create some visuals and reports based on the "issues" database. One of the charts I'm trying to build requires me to filter based on a date field containing a…
-
Tab Functionality in Beastmode Editors Broken
For years when pressing tab on the keyboard when in a DOMO code editor it has functioned like an auto complete or a tab space entry, however recently this functionality has broken. Tab no longer autocompletes nor does it allow to add quick spacing for code readability. Instead, it moves to the next element in the beastmode…
-
Can I show positive (instead of negative) numbers in red?
I have a table that shows YoY comps as a percentage for four different metrics. For three of the metrics, negative is bad and positive is good. For the fourth metric, negative is good and positive is bad. I found the option to "Show Negative Numbers in Red", which works correctly for three of the rows but not the fourth.…