Variables

How can I set up a text box Variable that can search for a text string in a field?
Hi Domo Community, Like the title says, I'd like to set up a Variable to be used in a dashboard where users can input text and it will search for the text string in related reports and return the results. For example, I have a "Description" field for items. I'd like to search "6mm bolt" in the Variable/text box and have it…
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…
Importing/Updating List from Dataset into Variable
We have found many use cases for a way to update a variable by bringing in a distinct list from a dataset. We've created a work around to do this through Workflows but having this be an included feature of variables would be ideal. Lindsay Gillespie Analytics Practice Manager | Graphable | lindsay@graphable.ai 💡 Need…
Variable & Control showing in a chart
In an App, to use a variable, you need to add a control → basically a filter card in an App or expand the card and see the control on the right side of the chart. However, it'll be easier if the control variable is showing in a specific chart like this, this way I don't need a separate card for to pick the variable control…
Efficient Way to Rollover Filters with New Month
I have a dashboard with monthly volumes by service line. In order to only show the prior month that is closed, I manually set a filter to the prior month. Instead of going through each card and updating this filter manually to the next month (current state), is there a way to automate this rollover? Or perhaps have a…
Control variable options that are populated by a dataset field or copy and paste
When creating a variable, we should be able to populate options based on a selected dataset field. Alternatively, there should be an option to paste values from spreadsheet rows to populate the variable options. Here's my use case: I built a dashboard that allows users to compare different markets. There are 150+ markets…
Quick Filter Displayed on Dashboard or App
Could quick filters on cards become something users can interact with from the dashboard or app? Right now, a viewer can only interact with it if they expand the card—ideally we could toggle the quick filter being viewed in the "appearance" settings and any dashboard or app viewer could interact with it right away. Or the…
Date Range Variables
Hello, Just getting into Variables and wondering if its possible to use Variables with Date Ranges. What I'm aiming for is this: - having two variables with each being a date range. IE variable 1 = 1/1/24-5/31/24 and variable 2 = 1/1/25-1/14/25. So the two periods can be any date range, and do not have to be the same…
How to add a new control variable
Hi Team, I was hoping you can assist me on adding a new control variable. Having some issues adding it. I have a card where its showing single value data that are in a status- Pending NI. So total number of tickets that are in Pending NI. And these Pending NI have dates on when the dispatch will happen. I want the user to…
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…
How to create WoW, MoM, QoQ, YoY dimensions to put into variable?
I want to create a dimensional variable that allows users to choose between WoW, MoM, QoQ, and YoY using the chart types below. What is the best way to go about this? Any tips on creating the ETL to create the components above?
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…
Variable fomat
I created a variable for year, I'm also using that variable as a dropdown selector filter as well in an App. But is there any way to get rid of the delimiter so that the variable show '2024' instead of '2,024'?
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…
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.
Smart Text as a Variable
At the card level it would be beneficial to know what the current operating environment is for a card and leverage that information in a beast mode. For example, if there were a "system variable" that stored what the current "Graph By" selection is, like what is already available in Smart Text, then you could have a beast…
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…
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…
Merged: Dynamic Date Variable
This discussion has been merged.
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?

Variables

Discussion List