-
Multi-Select Variable
The ability to toggle a variable to be multi-select (in string type only) that will create a comma delimited string of all the values selected from the variable.
-
Variable control at card-level does not ever show all variables
The UI on the variable control when looking at a card in Expand Details mode is not big enough to actually work with the variable. It seems to only populate 2 options, and the scroll bar makes it super hard to actually see what they are. Unlike Quick Filters, which expand to the height of however many items are in them…
-
BeastMode code to take one value from each category
This question is going to be really difficult to describe, but I will try anyway. I am trying to get a unit count for each facility, the problem is that bc we filter by time and different facilities can gain units over time, I can not just have one row per facility, I have a row for each month. That being said I need it to…
-
MS Office PowerPoint Variable Integration
Hey Community, We are looking to get some better integration with variables in the office plugins. Specifically, we are looking at the Powerpoint plugin, and we want to be able to bring in cards and dashboards that have Beast Modes utilizing Variables in the calculations. Perhaps something like you do for Filters, the…
-
Increase Variable Description Display Options
Currently if your Variable Description is too long, it just cuts off with … and there is no hover interactivity. Please allow more display options for the Variable control descriptions on a dashboard, such as word wrap or display on hover.
-
Period over Period Beast Mode
I have the following Beast Mode working for a comparison table (Period over Period is the name of the variable: CASE WHEN Period Over Period = 'Week over Week' THEN (CASE WHEN WEEK(Date) = WEEK(CURDATE() - INTERVAL 1 WEEK) AND YEAR(Date) = YEAR(CURDATE() - INTERVAL 1 WEEK) AND DAYOFWEEK(Date) <= DAYOFWEEK(CURDATE()) THEN…
-
NUMBER_FORMAT function
Please consider the implementation of a NUMBER_FORMAT function in Beast Mode in the same vein that we have DATE_FORMAT and TIME_FORMAT. This would take a number, and based on parameters, format the number (add thousand separator commas, percent sign, currency sign). Numerous discussions have been had in the forums about…
-
Unable to add a control to the dashboard
Hi I created a variable and implemented it at the card level where it behaves as required. However when I try to add it to the dashboard via the adding controls icon, I get the message "Add a Variable to a Card on this Page to add a control here". I have already added the card there. When I go the edit mode for that card,…
-
Sort or Re-Sort Available Values in Variable List
Variables continue to be a game changer for our company. One particular use case we have implemented is to create a variable with a list of all item attributes. As the list has grown the available attributes are no longer sorted in a logical way (for example, alphabetical A-Z). I think everyone could benefit from the…
-
Dynamic Date Range Comparison Using Variables
Hi there, I recently saw this video on DOMO Variables from Zack Cameron and around the 17:30 mark he's using variables to control the Time Range (YYD,QTD,MTD,WTD) and Time Comparison Option (YoY, PoP). This functionality would be perfect for the dashboard I'm building out, but I'm having trouble recreating it. The code for…
-
Same Variable Name on Different Datasets
Hello, I was wondering if there's a workaround to use the same variable name across different datasets? Right now it seems like variable names need to be unique and used across the instance. And so when we try to create some generic names, the variables would need to have different names. Is it possible for one set of…
-
Include Variable modifiers inside a filter card
I have my dashboard set up so that the filter options displayed are modified by the value of the variable. EX: notice how the filter by time options change depending on the time frame adjuster value in the screenshots. This is the best way I have found to do it, but my employers find it still extremely unintuitive. I think…
-
Can you set a default a value for a control that may be different than a default value on dashboard?
We have set a control value set on the card, but once we drop it onto a dashboard, the default value changes. In this first view you will see we are using filter cards to set values within the dashboard. Here is this view is our default value on the card, which is what we want this card to use. Then here is what the card…
-
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…
-
Dynamic Date Variable
When using a date variable, a new default value 'Today's Date' should be an option. It should take the date of the current timezone of your instance. This seemingly simple update would be powerful for my team. Right now, any dashboard using a variable is then not able to be turned into a scheduled report because the date…
-
Variable names in String
Hi, The current variable selector accepts the values either in Default (Numeric) - Gives a comma separator automatically. Percentage Currency - Adds $ as prefix. Do we have any work around to avoid comma? Do we have any work around to use other currency symbols as prefix with currency format?
-
Drilldown tables on cards displaying info from multiple dates
I have a card that uses variables to display info from different date ranges - some columns show metrics for a custom date range (defined by the variables) and other columns show metrics for the current month. When I add drilldown tables the date filters seem to get confused - it keeps picking the current day, even though…
-
Variable Combination Suggestions via Color Enhancement
We have used text based variables to allow users to select from multiple metrics to see in a single card. This can be very powerful when combined with the recent beast mode within a beast mode feature but one downside is that consolidating cards into one removes one of the benefits of a higher number of cards which is that…
-
Custom date range in a App Control
Hello, I'm working on a App with multiple cards, all with the same date column in the data. I would like to take the custom date range that's available in the filter options: And add this to a Control at the top of the App: Thegoal being the users can filter all the cards by any date range they want. I figured out how to…
-
domo.onFiltersUpdate to include Variables with DDX Brick
Please add the ability to update bricks on variable updates just as the bricks update with page filters changes.
-
App Studio - Notebook Card Smart Text for Variables
Hello, in App Studio I have a notebook card where I am using Smart Text to display the selected results from both a page filter and also a variable selection. The page filter selection is showing correctly in the smart text, however the variable smart text seems to get stuck on the default value and will not show the…
-
Add dynamic columns in variable dashboards
If Domo has the option to add dynamic texts in columns, that would be super helpful for variable dashboards. Currently, I have variable buttons of TY, LY, TW, Last 2 Weeks, etc, and Spend 1 and Spend 2 as column titles but if we can have TY Spend and LY Spend and TW Spend, etc. as the column titles, that would be an…
-
Using Variables to Pick "Closest Date"
Hey! I wasn't sure if this went in Variables or Beast Mode questions. I have data that is currently structured: Opp Name - Value - Date Updated A - 100 - 3/15 A - 80 - 3/30 A - 120 - 4/5 B - 50 - 4/1 B - 75 - 4/7 The outcome I'm looking for is for a User to be able to input a Date (say 4/1) as a Variable and then have the…
-
How do you create multi-select controls?
As far as I know Variables can only have Controls that are single selection, is there a way to create mult-select variables and by extension multi-select controls?
-
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…
-
Dynamic Column Names in Tables
The introduction of variables allows you to create much more dynamic table cards where the user can pick and choose which columns he/she wants to see inside the Table/Pivot Card. However, Variables only changes the data that shows up inside the table, it currently can not affect the Column Name so i have to end up naming…
-
Variable Control Title and Descriptions - Ability to Format Text
The current way that Variable controls show up on a dashboard are non-configurable. To add to this, they look completely different than the current Dropdown Selector Filter Cards. My ask would be to allow formatting for the Variable Title and Description to be selected when Editing the Dashboard, with the following types…
-
How to make the math right with variables as filter
I'm using variable as the filter for a dashboard. Basically I created variables named "timeframe" with values of Month, Quarter & Year On the breakdown, it works perfectly with timeframe as dimension. However, for the summary card, i used timeframe as the filter with the below SQL Funny thing is if I pull out sum('Budget')…
-
Apply color rules to variable values
When working with variables, it would be a great feature to allow to set color rules for all the values in the fields within the variable. This way, when the variable is applied in more than one chart in a dashboard, we can easily spot trends or make comparisons within the categories. For example: For a variable that…
-
Multi Select Variables?
I am building a dashboard that analyzes what the specific categories of items in any given transaction. For this example, let's assume there are 4 potential categories [Milk, Eggs, Bread, Fruit] on any given order. The end goal is to allow the user to select one or more of these categories in a slicer card (or similar),…