Dynamic Date in card tittle

The objective is to add max date of "open date" column in the card tittle.
For example: Open date max date is 11/22/2024
My card tittle will be: "Opened Account as of 11/22/2024"
I am thinking to use beastmode and create a calculated field with "max(open date)" but when I'm using smart text function in the tittle to add this calculated field it won't work.
Any suggestion please? Thank you!
Best Answers
-
Unfortunately, the smart text doesn't allow for that in the card title. I have utilized the summary number to display this information. You can create a beast mode that utilizes the CONCAT function and your MAX date to do it. Something like this:
CONCAT('Open date max date is', MAX(opendate))
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Try this:
CONCAT('<span style="font-size:10px;">Data as of ', MAX(
Transaction Date
),'</span>')**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
Unfortunately, the smart text doesn't allow for that in the card title. I have utilized the summary number to display this information. You can create a beast mode that utilizes the CONCAT function and your MAX date to do it. Something like this:
CONCAT('Open date max date is', MAX(opendate))
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Hello coach @MarkSnodgrass this works, Thank you!
0 -
Hello Coach @MarkSnodgrass additional question, is there a way to change the font size of summary number? it is looking too big. I tried to check in the formatting options but no luck. Thanks!
0 -
You can add HTML/CSS in the beast mode and add color and control the sizing. A simple example would look like this:
CONCAT('<span style="color:red;font-size:10px;">Vehicles</span><br />', SUM(
Vehicles
))One thing to note, you won't see the changes while you are editing in Analyzer. You will need to Save and Close in order to see the changes.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Hello Coach @MarkSnodgrass
I found this interesting:
This is my calculation in beastmode:
I can't figure out how to create a calculation in beastmode to change the "font size" with my existing calculation above. I am getting syntax error. Please help 😅 Thank you!
0 -
Try this:
CONCAT('<span style="font-size:10px;">Data as of ', MAX(
Transaction Date
),'</span>')**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Hello coach @MarkSnodgrass this works, Thank you!
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive