Set the default value of date type Variable to current date or today's date
A date type variable needs to have a functionality where the default value can be set to today's date
Comments
-
Big Time Need for Date Variables:
Set the default to MYSQL functions like Current_Date. I would guess that 80% of users would prefer this to be the default for a date variable.
0 -
0
-
@user00344 I'm not sure if this is what you're referring to, but there is already a CURRENT_DATE function in beast mode
1 -
It will be good if we can set up a specific default date for a date variable.
It is particularly important for a date variable.
Many thanks,
0 -
-
I would relly urgently need this functionality for a customer project,
and specifically I would need to have the possibilty to select the current month or week 😃
please 🙏
Thank you very much!
13 -
I agree this is a must have.
Thanks
Marialisa
5 -
When using date variables we have to define a specific value, it'd be great if it would allow the selection of today as a default as I'm typically wanting to use today's date with the variables. This would also allow me to not have to keep updating the default date as it gets farther away from the current date.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Domo,
Please combine these upvotes with the upvotes from an earlier Idea Exchange with the same request.**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Hello, I am working with a large Enterprise customer who is loving the new date variables functionality but is running into a challenge with the inability to set 'Yesterday' as the default date. As example, they can default the date variable to a static date but cannot default it to a dynamic date.
Whenever a viewer lands on the dashboard, the idea is to default the dashboard insights to yesterday.This request seems similar to other popular Product Feedback requests submitted here in Ideas Exchange:
Thank you Domo Product Management!
Casey Dorman (Domo CSM).
0 -
@Casey_Dorman {Domo} being able to use a formula for this would be a great solution so you could then default the date to the end of the last week or the end of the last complete month.
1 -
Would appreciate if this function is available
0 -
Completely agree, being able to set the default value for date variables to relative dates would be a huge improvement, and the amount of other thread asking for similar things (set it to Today(), Yesterday(), etc) shows how many people in the community are looking for this.
1 -
I would also urge an enhancement be made to the date variable. Currently we are forced to hardcode a date as the default value and resort to manually updating it to keep it relevant. It should / can be so much smarter.
0 -
This functionality is definitely needed. Other BI systems like Birst already have it and it can be programed in various ways.
0 -
Yes please 🤞
0 -
Any updates on this? This is sorely needed!
0 -
Thanks everyone for the feedback. This is definitely something we're discussing and are looking to add in the future. No ETA at the moment but this is on the list of features to add!
Matt Tannyhill
Domo – Product Manager
Data Analysis & Visualization
2 -
We would like to raise a feature enhancement request, that I will make the Date Variables default values to be changed dynamically according to the current date.
Default values like Current Date, and yesterday would be good to have.
At the moment the values are defaulting to the value set up by Domo
Refer Dashboard - https://marqueeretailgroup-dev.domo.com/page/1387153048
0 -
Agreed. Helpful to have it be (Today - 7) etc. as defaults. Not as valuable as it is currently.
0 -
Great feedback @DomoFaye, we're looking into adding this functionality in the future.
Matt Tannyhill
Domo – Product Manager
Data Analysis & Visualization
0 -
@user00344 great idea! Hope you don't mind, I updated the title of this post from 'Date Variables' to 'Relative Date Variables' to be a bit more specific. This is definitely something we are hoping to add in the future, along with several other enhancements to Variables. Thanks for sharing!
Matt Tannyhill
Domo – Product Manager
Data Analysis & Visualization
0 -
@GrantSmith great feedback. This is definitely something we are hoping to add in the future, along with several other enhancements to Variables. Thanks for sharing!
Matt Tannyhill
Domo – Product Manager
Data Analysis & Visualization
0 -
Add first/last day of current/prior months as well. I spend a LOT of time updating these default dates for date pickers at month-end. Unfortunately because the user date filters are not exposed in the beast modes, I'm forced to use these date picker controls everywhere!
0 -
Any ETA on this? Need it! Pretty please!
0 -
Also - just a note that this same request seems to appear in multiple threads/locations with additional upvote counts.
0 -
+1
0 -
Very curious about upcoming enhancements to variables - I have started to use and love them, but the Admin is really tedious.
Broadway + Data0 -
I'm curious if anyone has used DDX Bricks to create custom script for creating a dynamic default date? If so, please share…
0 -
I also need this date variable default functionality. Or even better - to be able to use a field i.e. `Month` to auto populate the variable options and a function MAX(`Month`) as the default value.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 727 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive