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
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!