Displaying information on a dashboard based on today's date and the past 7 days
Carol-Anne Cerbone
✭✭✭✭✭
Hi
I have created a dashboard with a chart widget (columns). It is currently displaying all of the information from my report. My report is using Summary Sheet information. The end user only wants to see the information for the past 7 days, not all of the data. Is there a way for the dashboard to automatically update on a daily basis to only show the last 7 days worth of data?
Thank you in advance for any assistance.
Carol-Anne
Answers
-
my suggestion would be to run a new/separate report filtered down to the last 7 days and run the widget off that new report. This will automatically update and should solve this issue.
Hope that helps. Let me know if you need any more detail.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!