为仪表板图表添加数据行需要重新格式化吗?
我创建了一个表格来存放我的数据,并创建了一堆与之相关的图表。例如,每行表示当周的数据。
但是……当我为新的一周添加新的数据行时,我发现我必须重新建立图表的数据字段,当我这样做时,我失去了图表的所有格式,必须再次重置所有图表。这不是长期可控的。例如,我有折线图,每个图表中只使用特定的数据列,垂直轴调整数据范围,图例位置等,一旦我指定了新的数据范围,我就失去了一切。
如果可以设置它,这样数据范围就会自动扩展,而不必进入并重置它,并且如果重置数据范围,那么格式化的所有内容都不会丢失。
谢谢!
评论
-
J.克雷格·威廉姆斯 ✭✭✭✭✭✭
我同意。请写一个增强请求。
https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409
我尝试构建使用滚动日历的系统。我刚刚完成了一个有5个季度日历的系统——当前季度、下一个季度和上一个季度。
在可预见的将来,不需要对输入数据的(几个)表提供的仪表板或报告进行更改。
我也尽量避免使用当前时间段名称的表格,例如TASKS 2018。
相反,我使用了TASKS或TASKS CURRENT YEAR。
在时间周期结束时,表通过给定它们的时间周期名称进行归档,并且各种对象可能需要更新以显示历史记录,但我也尝试在设计中避免这种情况。
即便如此,至少当前的生产可以在交叉期间继续进行,而不会产生不ob欧宝娱乐app手机下载必要的压力。
克雷格
类别
OMG, I didn't click on the widget box, now I see the edit option. Thanks so much, this is going to be a game changer for me!<\/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":106511,"type":"question","name":"Smartsheet Form & File Attachment","excerpt":"Hello, is it possible to have the file uploaded on a smartsheet form to be attached to the email notification?","categoryID":321,"dateInserted":"2023-06-15T17:47:43+00:00","dateUpdated":null,"dateLastComment":"2023-06-19T18:45:05+00:00","insertUserID":162431,"insertUser":{"userID":162431,"name":"Syd","title":"Analytics Manager","url":"https:\/\/community.smartsheet.com\/profile\/Syd","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!CRvWwjtq8Dw!neNVX5cBEbo!R6y12vmDgYo","dateLastActive":"2023-06-19T18:44:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":138637,"lastUser":{"userID":138637,"name":"StevenBlackburnMBA","title":"Director, Informatics Innovation","url":"https:\/\/community.smartsheet.com\/profile\/StevenBlackburnMBA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/30MFCHQD4VJ8\/nA6GUCC5S5SQG.jpg","dateLastActive":"2023-06-19T21:30:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":69,"score":null,"hot":3374056368,"url":"https:\/\/community.smartsheet.com\/discussion\/106511\/smartsheet-form-file-attachment","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106511\/smartsheet-form-file-attachment","format":"Rich","lastPost":{"discussionID":106511,"commentID":381199,"name":"Re: Smartsheet Form & File Attachment","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381199#Comment_381199","dateInserted":"2023-06-19T18:45:05+00:00","insertUserID":138637,"insertUser":{"userID":138637,"name":"StevenBlackburnMBA","title":"Director, Informatics Innovation","url":"https:\/\/community.smartsheet.com\/profile\/StevenBlackburnMBA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/30MFCHQD4VJ8\/nA6GUCC5S5SQG.jpg","dateLastActive":"2023-06-19T21:30:05+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-19T18:44:06+00:00","dateAnswered":"2023-06-15T18:43:26+00:00","acceptedAnswers":[{"commentID":380872,"body":"