Smarttext showing actual dates used
Hi guys,
Quick question about smarttext. I have a dashboard and the widgets show stuff like This Year etc but I want the dashboard to actually show me the dates somewhere.
So if the user select last week somewhere it would have 18/07/2022 to 24/07/2022.
Can this be achieved?
Thanks
Paul
Best Answer
Answers
-
It doesn't appear to be currently possible within the smart text on a title however you can utilize a notebook card and add a summary number to display the minimum or maximum values in your dataset.
https://domohelp.domo.com/hc/en-us/articles/360043430233-Adding-a-Notebook-Card#4.
I'd also recommend adding this as an idea to the idea exchange on the Dojo for product to look at.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Thanks. Unfortunately it doesn't look like the summary number works for dates. I may be mistaken.
0 -
@Jones01 You can customize your summary number by wrapping it in a CONCAT() function like the examples in this article: https://domohelp.domo.com/hc/en-us/articles/360043430093-Sample-Beast-Mode-Calculations-Card-Element-Transforms#4.
Here is an example of what that could look like:
CONCAT(DATE_FORMAT(MIN(`Date`),'%m/%d/%y'),' - ',DATE_FORMAT(MAX(`Date`),'%m/%d/%y'))
2 -
Thanks. That worked to an extent but when you filter the dashboard by a different range on the global date selector this doesn't get updated and just stays at the min and max date across the dataset.
It only updates if you use the Filter Views option.
0 -
@MichelleH spot on. thank you so much for your help with this.
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 437 Beast Mode
- 23 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive