Card updates later in the month than other cards - Beast Mode to keep previous value until update?
Good morning,
I have a dashboard with cards set to update once the month turns over - however several of the cards display data that update about seven days post-month change. During that seven-day period, the cards display no value. Is there a Beast Mode that would allow for the cards to continue to display the prior value until the new monthly data rolls in?
Thanks!
Answers
-
There are various ways to dynamically do this. I made a video about using dates to control what is visible on a card. You can watch it here and see if it applies to your use case.
**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.1 -
Almost - the Same Point of Month filter feels close. Can that be changed in some fashion to say "on X day of the month, update the card value"?
0 -
@Joe_M Would using a beast mode like the following work for the date on those cards?
case when DAY(CURDATE()) < 7 then DATE_ADD('Date', interval 1 month) else 'Date' end
This says whenever the day of the current month is before the 7th, add one month to the dates in the 'Date' column (show the previous month). On the 7th or after, don't modify the date (show current month). Not 100% sure if it will work but worth a shot.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
1 -
What are you using for your date range filter? Do you have set to this month? Or do you have it set to All-time?
If it is set to this month, then it will always show the current month regardless of any beast mode you create. I would probably set it to the last 2 months and then use a beast mode to do the toggling between months based on what day of the month it is with a nested case statement.
**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.1 -
Thank you both, Mark & Rob. Going to try some of these out and will report back on what works.
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
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 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