仪表板上缺少数据
吉尔Schoenwandt
✭✭✭✭✭
有人遇到过仪表板报告突然显示数据丢失吗?报表已经在仪表板上几个月没有最近的变化，但是昨天超过50个报告开始显示为丢失数据。报表是从Sheet Summary数据创建的。
1
答案
-
吉纳维芙P。 员工管理如果创建小部件的用户不再具有访问仪表板或源项目的权限，则会出现此错误。为了解决这个问题，编辑而且保存小部件。这应该允许小部件采用最后一个编辑它的人的权限。
查看Report widget部分底部的“备注”，在这里:智能表仪表板的小部件类型
如果这是问题，请告诉我!如果没有，你可能想要联系Smartsheet技术支持包含屏幕截图、仪表板名称和创建报表/小部件的用户的电子邮件地址。
欢呼,
吉纳维芙
0 -
吉尔Schoenwandt ✭✭✭✭✭
非常感谢您的回复-我是报告的创建者，在看到这个问题之前没有对他们做过任何编辑。我会联系后援部的。
0 -
凯拉 ✭
在此为其他遇到此问题的人提供更新。根据Smartsheet Support，这是预期的行为。必须重新构建小部件或进入每个Dashboard和每个小部件以获得它的所有权是非常耗时和令人沮丧的。每个使用Smartsheet的组织都有人员流动。他们如何有一个平台来限制这种类型的变化是令人兴奋的。
但截至2022年5月，没有解决方案，似乎也没有任何担忧。
0 -
凯拉 ✭
@Genevieve P。-上面的链接，我在你提供的链接中没有看到“备注”。我确实看到了星号，但是没有符号来表示这是什么意思。
我找到的关于这种“预期”行为的唯一信息是通过社区。Smartsheet没有直接提供(我能找到的)当你删除Dashboard创建者共享管理或所有者权限访问时，你必须重新构建或重新链接小部件。
必须重新构建小部件或进入每个Dashboard和每个小部件以获得它的所有权是非常耗时和令人沮丧的。每个使用Smartsheet的组织都有人员流动。他们如何有一个平台来限制这种类型的变化是令人兴奋的。
但截至2022年5月，没有解决方案，似乎也没有任何担忧。
我为一些仪表板找到的解决办法是复制/保存为新的。但这也有缺点，需要手动更新，这取决于系统的构建方式。
0 -
吉纳维芙P。 员工管理
自从我最初的评论以来，Dashboard文章已经更新;请参阅这篇专门针对报表小部件的文章:删除创建报表或图表小部件的用户
我还建议向您的系统管理员提供这篇文章，以帮助您将来进行所有权转移:使用非破坏性转移来更改工作表、报告或仪表板的所有权
我希望这能有所帮助!
吉纳维芙
0
类别
You can use Conditional Formatting to set a color based on the value in a cell, but not to randomize the colors unfortunately. It's a fixed color per formatting rule. You could use a contact field to use different colors for different people though...maybe have every project that George is managing be in dark blue, Wanda in orange, etc. Or some other value that you preset (big projects in red, small in green, etc) that has enough variation to help with the visuals.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-08-25 18:00:14","updateUser":{"userID":151609,"name":"longlive289s","url":"https:\/\/community.smartsheet.com\/profile\/longlive289s","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-25T21:17:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"}]},{"discussionID":94645,"type":"question","name":"When will report card views be editable on dashboards and workapps","excerpt":"The sheet card view functionality works so beautifully on dashboards and workapps 😍 (image attached of sheet setting options on workapps). Will this be available soonish for card views on reports? Currently, the only editable report option is grid view on workapps. The workaround I'm implementing is to add the card view…","categoryID":321,"dateInserted":"2022-08-25T01:27:07+00:00","dateUpdated":null,"dateLastComment":"2022-08-25T13:29:01+00:00","insertUserID":122359,"insertUser":{"userID":122359,"name":"Amanda G Lima","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Amanda%20G%20Lima","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!aTlUGrCEcLw!XmjWXyseFaQ!SRWK24M5uLR","dateLastActive":"2022-08-25T14:28:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-08-25T13:34:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3322825568,"url":"https:\/\/community.smartsheet.com\/discussion\/94645\/when-will-report-card-views-be-editable-on-dashboards-and-workapps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94645\/when-will-report-card-views-be-editable-on-dashboards-and-workapps","format":"Rich","tagIDs":[265,292,371,391,444],"lastPost":{"discussionID":94645,"commentID":341152,"name":"Re: When will report card views be editable on dashboards and workapps","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/341152#Comment_341152","dateInserted":"2022-08-25T13:29:01+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-08-25T13:34:15+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":"2022-08-25T14:29:27+00:00","dateAnswered":"2022-08-25T13:29:01+00:00","acceptedAnswers":[{"commentID":341152,"body":"
Fell free to brows the Ideas Topic. If someone has already made the suggestion, you can vote for it. If no one has then you can submit the idea yourself to let Smartsheet know it is a requested feature and allow others to vote for it.<\/p>
<\/p>
