Line Chart - Sheet Structure for multiple values
Hi All
I've searched for a solution but again, being so used to just being able to select columns and rows in spreadsheet apps I'm really struggling with creating a line chart which has several columns of data I need to turn into a single visual for my dashboard
I want to show the number of tasks raised by MONTH for each Account (see example below and apologies for the mansplaining of the dimensions/metrics, just trying to avoid confusion)
Month = X Axis
Count of Task = Y Axis
Account = Line (by account)
The Task column isn't all that relevant as I just want a count of tasks by account by month so I can show the trend for each but I genuinely have no idea how to structure the data in Smartsheet to achieve this
I've tried to create another sheet to COUNTIFS the instances but I'd rather it come directly from this sheet so when new instances are added the chart updates automatically
Annnd, I've not yet fully learned how to use summaries to create Dashboard items and don't really know where to begin with that
Again any videos, support and/or guidance would be greatly appreciated
Thanks
Dan
Best Answer
-
No worries, I've figured it out
Answers
-
No worries, I've figured it out
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 58 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!