Smart Text - Show Actual Year Value, Rather Than Date Range
I am working on developing an annual report for our department. I wanted to find out how you go about showing the actual year value, rather than the date range value, like "Previous Year", on the cards. In this example, I would rather show the year, "2022", rather than "Previous Year".
Best Answers
-
Colemen's instructions should work. Try using the summary rather than smart text option:
1 -
Hmm okay. Question, if the year for the annual report is at the top of the page, first red circled "previous year" on your dashboard, then why do you need the year for each individual card? I would say best practice is to avoid adding dates in card titles, as shown here:
You could make the first single value card at the top of the dashboard under SFVD Annual Report powered by a beastmode which would not require smart text, would be dynamic and would give context for the entire page.If I solved your problem, please select "yes" above
1 -
@drewswayne awesome. Also, you can hide the title on any card on a dashboard by putting the dashboard in edit mode, clicking the "edit content" option on the card, choosing "appearance", and deselecting "title".
1
Answers
-
You will need to create a beastmode that displays the value you want "2022". Then use the filters option for smart text. When you filter the data to 2022, the beastmode value will be 2022 and that is what will be shown in the smart text.
If I solved your problem, please select "yes" above
0 -
Thanks for the help! Unfortunately, the smart text won't display my value.
Here's the beast mode calc that I'm using: MAX(YEAR(
IncDateDST
))0 -
Colemen's instructions should work. Try using the summary rather than smart text option:
1 -
Hmm okay. Question, if the year for the annual report is at the top of the page, first red circled "previous year" on your dashboard, then why do you need the year for each individual card? I would say best practice is to avoid adding dates in card titles, as shown here:
You could make the first single value card at the top of the dashboard under SFVD Annual Report powered by a beastmode which would not require smart text, would be dynamic and would give context for the entire page.If I solved your problem, please select "yes" above
1 -
Thank you both for your help.
@jessdoe, your suggestion ended up as the one I implemented. I'm able to have a clean looking header in the report, which now includes the appropriate filtered date.
@ColemenWilson, I appreciate your suggestions and thank you for link to best practices. I removed the date related info out of all card titles as suggested. The single value card didn't really work for me, because I was forced to have a title on the card. Also, I don't see where I am supposed to select "yes", when my problem was solved.
1 -
@drewswayne awesome. Also, you can hide the title on any card on a dashboard by putting the dashboard in edit mode, clicking the "edit content" option on the card, choosing "appearance", and deselecting "title".
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive