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
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives