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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive