仪表板上的折线图小部件
我试图画出两组信息。
我想要的一个数据集显示为一条平线，如下面的截图所示。
其他数据集将是我想显示为数据点的实际结果(再次显示在屏幕截图中)。
我还附上了源数据的截图供参考。我有2列/月，一列是实际，另一列是每月的100%。
这可能吗?
答案
-
BullandKhmer ✭✭✭✭✭
你好,
首先，我不相信这是可能的，我很确定SS不允许线+散点图。据我所知，你能做的最好的就是两条线在你的情况下一条直线和另一条可变线。
要构建两条线形图，您需要构建一个包含“预计”和“实际”或类似两行的度量表。为每个月添加列，并使用公式填充行，然后在此工作表上构建折线图。
如果你需要更多帮助，请告诉我。
-
Jeff_Berman ✭✭
@BullandKhmer谢谢你的回复。我理解你的反馈，感谢你花时间回答这个问题。
再次感谢!
类别
<\/p>
You can send notifications to any valid email address. If you're planning to send alerts or reminders with a link to the sheet, the user will not be able to click the link and access it if they do not have a Smartsheet account and not shared to the sheet.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106482,"type":"question","name":"Smartsheet Bridge","excerpt":"Hi, I'm on Enterprise Plan and I'm trying to use Bridge but cannot log in to it. I actually had to dig the login link from the forums because I could not find it anywhere else, and when I try to sign in using my Smartsheet account it says \"Unable to log in with Smartsheet credentials at this time, try using Bridge…","categoryID":321,"dateInserted":"2023-06-15T08:35:55+00:00","dateUpdated":"2023-06-15T08:38:14+00:00","dateLastComment":"2023-06-16T08:51:39+00:00","insertUserID":149908,"insertUser":{"userID":149908,"name":"orad","url":"https:\/\/community.smartsheet.com\/profile\/orad","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pDFQaXDtqPs!u9_Rl3ztpP0!b22gvzMblTD","dateLastActive":"2023-06-18T01:37:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":149908,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-17T21:03:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":40,"score":null,"hot":3373725454,"url":"https:\/\/community.smartsheet.com\/discussion\/106482\/smartsheet-bridge","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106482\/smartsheet-bridge","format":"Rich","tagIDs":[369,448],"lastPost":{"discussionID":106482,"commentID":380976,"name":"Re: Smartsheet Bridge","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380976#Comment_380976","dateInserted":"2023-06-16T08:51:39+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-17T21:03:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-16T04:53:08+00:00","dateAnswered":"2023-06-15T09:36:11+00:00","acceptedAnswers":[{"commentID":380710,"body":"
Hi @orad<\/a> <\/p> I hope you're well and safe!<\/p> Bridge is a Premium Add-on\/app that needs to be acquired separately. It's not included with the Enterprise license.<\/p> Here's a possible workaround or workarounds <\/strong><\/p> I recently developed an SMS solution for a client using 3rd-party services, Zapier and Twilio.<\/p> Is that an option?<\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":369,"urlcode":"bridge-by-smartsheet","name":"Bridge"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]},{"discussionID":106462,"type":"question","name":"Why do i need \"admin approval\" to use the smartsheet app in teams?","excerpt":"I'm trying to add a Smartsheet to a teams channel as a tab and I get the error: Admin approval needed. Smarsheet needs admin approval to enable channel level sharing for this app. You may continue without this feature, or, if you're an admin you may use the button below to grant approval. But hitting the \"grant…","categoryID":321,"dateInserted":"2023-06-14T20:14:51+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T20:43:43+00:00","insertUserID":161989,"insertUser":{"userID":161989,"name":"PGoodwin86","title":"Sr. Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/PGoodwin86","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T20:41:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161989,"lastUser":{"userID":161989,"name":"PGoodwin86","title":"Sr. Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/PGoodwin86","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T20:41:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":43,"score":null,"hot":3373550314,"url":"https:\/\/community.smartsheet.com\/discussion\/106462\/why-do-i-need-admin-approval-to-use-the-smartsheet-app-in-teams","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106462\/why-do-i-need-admin-approval-to-use-the-smartsheet-app-in-teams","format":"Rich","lastPost":{"discussionID":106462,"commentID":380649,"name":"Re: Why do i need \"admin approval\" to use the smartsheet app in teams?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380649#Comment_380649","dateInserted":"2023-06-14T20:43:43+00:00","insertUserID":161989,"insertUser":{"userID":161989,"name":"PGoodwin86","title":"Sr. Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/PGoodwin86","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T20:41:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-14T20:42:10+00:00","dateAnswered":"2023-06-14T20:41:29+00:00","acceptedAnswers":[{"commentID":380647,"body":" You will have to get an admin of Teams to allow the Smartsheet for Teams app in the admin console of Teams.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5380,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
