How do I create a hyper care Line Graph for a dashboard
I need to create a specific line graph for a dashboard. This is what was requested but I am unsure how I need to structure my metrics sheet? X-axis = Dates, Y-axis = Number of stores. One line graph (in the case below, the Squared Milestones) would show the number of stores we planned to upgrade every day, and the other line graph (the Diamond) will show how many we actually upgraded (could be we didn’t have gear, tech didn’t show up, store manager was not there, etc). Lastly, the columns should represent the number stores where we had issues upgrading the site and went into hyper-care. (This graph will represent a large amount of store upgrades) Graph visual below.
Answers
-
There is currently no way to combine graph types within Smartsheet, but there is a bit of a workaround to have all of it in a single graph type. Feel free to reach out to me on LinkedIn if you would like to explore that a little bit more. It wouldn't be EXACTLY how you want it, but we can get pretty close. We just wouldn't be able to use the squares and diamonds (but can use different colors).
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
- 145 Just for fun
- 62 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!