-
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…
-
Toggle Auto Preview on/off at the instance level (Company Settings)
As Domo admins, we should be able to control whether Auto Preview is automatically enabled when users launch Analyzer in our Domo instances. This is especially important as Cloud Amplifier is implemented because of the potential cost implications of, for example, querying Snowflake each time a user modifies almost anything…
-
"Colors" shows limited options based on Beast Mode
I used Rank & Window ETL to Rank Districts 1-46 based on a performance value. I need to use the "Colors" feature in Analyzer to color code rows based on a "Tier" I created in a Beast Mode, which is calculated based on percentile. The Beast Mode is as follows: In the preview, this works. Ranks 1-11 are D, 12-23 are C, etc.…
-
Personal Use Domo Platform
The competitor-that-must-not-be-named () has a public version for personal use and distribution. This allows for refinement of skills, freelance use, and public portfolio building. Does Domo offer anything similar? It doesn't seem like it, but I'm surprised that we don't.
-
Pivot/Group By - Make Multiple rows into one row and add columns
Hi Community - thanks as always for the consistent great help. I'm attempting to Group/Pivot/Join/Append (not sure exactly what the methodology will be) multiple rows of Patients into single rows with additional columns. Right now, each patient event is on it's own row. So, a patient seen on Monday and then also on Tuesday…
-
Capability to Change size of Summary Number within Analyzer Card
Hello, I was wondering if there is some capability to change the size of the Summary Number within an Analyzer card without having to use a Brick or an App. This would give me some great flexibility as I could then fine tune what I could show in my cards without having to struggle through javascript, css, and html.
-
Allow for "Other" category in mega-tables
I would like for there to be the option to define the max number of rows in a mega-table before grouping all others into an "Other" group. This functionality exists on bar charts, just looking for the same thing in tables. The idea originated because a lot of the time I want to be able to show to top N rows in a table, and…
-
How do I flip the x axis on a vertical bar chart?
I have a vertical bar chart that has a goal of 25. The user is confused because the goal is "anything under 25 is good" but with how the chart looks it looks like you are trying to reach 25 because the goal is set at the top of the card. Is there a way to flip it so that the x axis is at the top of the card and thus makes…
-
Tooltip Card Visualizations + Improvements
I would love the ability for cards to render inside of tooltips. Rather than having to drill down into a new card/drill-in-place. I'm imagining being able to have hover over a bar (say annual data) and then see the same visualization by quarter or month. Or being able to hover over a total bar, and see the same thing split…
-
Using Weighted Data with Cards
When working with data and building cards, is there any way to utilize beast modes to apply a weighted value across multiple variables? There is a weight variable within the dataset, and we are trying to apply those varying weights and display the updated values on a dashboard. Does the SQL syntax have the capability of…
-
Multi-Value Card - Revenue and YOY % Change
Hello Community, I need help creating a multi-value card in Domo to show total revenue and year-over-year percentage change based on filter selection. The requirements are: Yearly Comparison: If for example FY25 is selected, show FY25 revenue and compare it with FY24. Similarly, for other fiscal years. Monthly Comparison:…
-
Tagging Customers on Services
Hi Community, excited to see what you think up! BLUF: How can I analyze what nurse saw a patient prior to a surgery or a non-surgery? See my simplified dataset below. My hope is to be able to see which nurses saw which patients/customers that led to a surgery (or not). My current thought is a CASE WHEN to create a label…
-
Allow for multiple calendars on Dashboard e.g. Fiscal, Business, Gregorian, Custom
Problem: Users want to have access to multiple calendars on a dashboard, and different users on the same dashboard may want to see their data from the perspective of their desired calendar. E.g. A finance user wants to see a dashboard through a fiscal calendar, but other users may want to see the same dashboard with a…
-
Lock all cards at once on dashboard
Hi, As I have around 40+ cards on my dashboard, its frustrating to go into each card and lock it individually to avoid users from editing. Is there any way this can be done at one place for the whole dashboard? I think this should stop the user from going to the Analyzer.
-
Settings not showing up in Analyzer
Usually there are a list of settings shown in the empty space I highlighted in the picture above. Is this some kind of glitch? I can't figure out how to make adjustments there.
-
Control Chart Type via Beast Mode
With the recent enhancement around beast modes that allows a beast mode within a beast mode it has become easier than ever to utilize variables to control x-axis, y-axis, sorting, filtering, etc. through beast modes. With that limitation out of the way I believe the next logical enhancement would be to add a Chart Type…
-
Beastmode field not aggregating in bar chart
I have a dataset containing the following data: The Sessions field is a beastmode calculating the rank of the customers phone number. (Running total of how many transactions they have) rank() over (partition by Location.ID, PhoneNo order by TransactionDate) I am wanting to create a horizontal bar chart with the number of…
-
Dynamic Goal line on a bar chart
I need to create a goal line dynamically on a bar chart. I have used scale marker in properties, but it is giving a static line. Can someone please suggest how can we achieve dynamic goal line. Thanks
-
Period over Period with Non-Time X Axis
First time poster!! Thanks for all the help you've contributed thus far Domo Community. I'm trying to create a year over year comparison graph with our locations on the X Axis, instead of the required time period on the x axis. The period over period comparisons are only available when Time is used on the x axis, so I…
-
Additional Currency Symbols
We are a global organization that operate in many countries. We have found a need to provide visualizations to our users in their local currency to avoid confusion and improve user experience. I'm happy to provide a list of the needed currencies but I would think Domo would benefit from adding most of the currencies around…
-
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…