仪表板上的折线图小部件
Jeff_Berman
✭✭
我试图画出两组信息。
我想要的一个数据集显示为一条平线，如下面的截图所示。
其他数据集将是我想显示为数据点的实际结果(再次显示在屏幕截图中)。
我还附上了源数据的截图供参考。我有2列/月，一列是实际，另一列是每月的100%。
这可能吗?
标签:
答案
-
BullandKhmer ✭✭✭✭✭
你好,
首先，我不相信这是可能的，我很确定SS不允许线+散点图。据我所知，你能做的最好的就是两条线在你的情况下一条直线和另一条可变线。
要构建两条线形图，您需要构建一个包含“预计”和“实际”或类似两行的度量表。为每个月添加列，并使用公式填充行，然后在此工作表上构建折线图。
如果你需要更多帮助，请告诉我。
-
Jeff_Berman ✭✭
@BullandKhmer谢谢你的回复。我理解你的反馈，感谢你花时间回答这个问题。
再次感谢!
类别
Apply a filter to the sheet and then you can select that filter in the Dynamic View.<\/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":106193,"type":"question","name":"Multiple Forms, One Smartsheet","excerpt":"I created two identical forms (except for the name) and both of them populated into the same smartsheet. Is there a way to only see one form's submissions?","categoryID":321,"dateInserted":"2023-06-08T13:28:04+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T13:47:26+00:00","insertUserID":152102,"insertUser":{"userID":152102,"name":"AllieB","url":"https:\/\/community.smartsheet.com\/profile\/AllieB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T13:49:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":66106,"lastUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-06-08T19:36:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":41,"score":null,"hot":3372467730,"url":"https:\/\/community.smartsheet.com\/discussion\/106193\/multiple-forms-one-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106193\/multiple-forms-one-smartsheet","format":"Rich","lastPost":{"discussionID":106193,"commentID":379551,"name":"Re: Multiple Forms, One Smartsheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379551#Comment_379551","dateInserted":"2023-06-08T13:47:26+00:00","insertUserID":66106,"insertUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-06-08T19:36:39+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-08T13:46:06+00:00","dateAnswered":"2023-06-08T13:44:25+00:00","acceptedAnswers":[{"commentID":379548,"body":"
