Charting Occurrences Over Time
Hello all,
Quick question about setting up a chart widget to show instances over time!
I've made a set of sheets and reports that feed into a dashboard to help visualize occurrences. I'd like to add in a chart widget that shows these events over time; nothing fancy - a simple line chart or scatterplot style would be great.
I set up an automated workflow that pulls the events that meet the conditions I'm looking for and copies them to a separate sheet. I tried to use this to chart over time, but received the "Selected data cannot be charted. Please select a new range." error message.
I made a report that extracts only the dates of those events, and tried to use that to chart over time, but received the same error message.
Does Smartsheet just not support charting over time? Is there a specific way that you have to present the data to the widget to allow it to chart dates?
I appreciate any and all advice on this topic; thank you in advance!
Answers
-
You can, but charts can only be created from numeric data (in addition to the labels). Are you able to provide screenshots for context?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives