图表实时更新

你好,

我们在Smartsheet中的图表功能上遇到了一个问题。我们目前正在使用Smartsheet来收集和处理服务台票证。我们有一个表单托管在我们的内部网,用户可以提交帮助台票。这些都是由我们的服务台团队在Smartsheet中的一张表格中收集和处理的(屏幕截图1)。然后我们有第二张表格,按月按状态提供一些简单的、汇总的统计表(屏幕截图2)。最后,我们正在试验一种“仪表板”,它只是提供了第二张表格中编译的信息的可视化摘要(屏幕截图3)。最后一部分是问题所在。我们将其设置为每2分钟更新一次,并且在呈现预期的数据方面似乎运行正常。然而,当原始源表(截图1)发生任何变化时,所有图表都会失效(截图4)。解决这个问题的唯一方法是导航到第二个总结表(截图2),从而同步中间商。有什么方法来解决这个问题,不涉及指向图表直接在表单数据?

1. png截图

2. png截图

3. png截图

4. png截图

评论

  • Sasan
    Sasan 员工

    雅各,

    感谢你让我们注意到这一点,并感谢你提供的截图。这个问题似乎超出了图表的范畴,因为度量小部件显示的是无效消息。你能提供一个屏幕截图(屏幕2)与底层公式,让我们说[提交]3单元格?

    谢谢

    Sasan

  • 没问题,见下图(截图5)。

    不确定是否相关,但我注意到的是,如果源表(上面的截图1)发生了变化,当我从仪表板导航到摘要表时,所有计算的单元格都会在一瞬间显示错误(截图6),就好像单元格还没有加载一样,然后错误消失,数据出现。因此,这几乎就像自从源工作表发生更改以来没有与摘要工作表进行任何交互一样,Smartsheet知道源发生了更改,但它没有在摘要工作表中处理该更改,并且一旦删除的仪表板无法解决差异,直到刷新摘要工作表....差不多就是这样。

    5. png截图

    6. png截图

  • Sasan
    Sasan 员工

    雅各,

    考虑到过去的一刹那,你的摘要表有#s,以及你强制刷新的仪表板,指标和图表是否显示数据并填充?

    谢谢

    Sasan

  • Sasan,

    是的,如果我先更新汇总表,然后再更新仪表板,那么仪表板图表就会按照预期呈现,但并不是所有访问仪表板的用户都必须访问汇总表或源表,我们希望仪表板能够反映底层数据源的实时(或相对最近的)视图,而不需要在每次发生更改时手动刷新底层数据源。

  • Sasan
    Sasan 员工

    雅各,

    不确定这是关于手动刷新底层工作表。这更多的是一个巧合的时机。当源工作表中出现新数据时,摘要工作表会自动更新。刷新仪表板小部件时,从摘要表中提取数据。在本例中,再次计时,当小部件查找摘要表中的数据时,摘要表正在使用源工作表数据进行更新,而在那一瞬间,它还没有计算出数字。因此,仪表板小部件没有要显示的#s。我认为更新摘要表和仪表板查找摘要表的空中碰撞是问题所在。我希望这对你有帮助。

    谢谢

    Sasan

  • Sasan,

    我倾向于同意你的观点,但每次对原始数据源进行更改时,我都可以重新创建这个问题,而每次,修复它的唯一方法就是导航到摘要表,并实际上“刷新”它。此外,一旦底层数据源发生了更改,并且图表无法加载到指示板中,刷新指示板本身也不能解决问题。也就是说,如果这是一个随机问题,仅仅是由更改和刷新调用的偶然冲突引起的,我希望它在随后的调用中自行解决。

  • Sasan
    Sasan 员工

    雅各,

    好的,很高兴知道。我们需要解决这个问题,然后给你答复。它独立于汇总表和基础公式。你能分享交叉表公式单元格选择器屏幕的屏幕截图吗?

    谢谢

    Sasan

  • 确定的事情。

    我不确定你到底想要哪个,所以这里是:

    • 月合计列的单元格引用-摘要表(截图7)
    • 月状态列的单元格引用-摘要表(截图8)
    • 状态度量的单元引用-仪表板(截图9)

    7. png截图

    8. png截图

    9. png截图

  • Sasan
    Sasan 员工
    编辑03/28/18

    雅各,

    谢谢。这很有帮助。我们发现@cell引用可能是罪魁祸首,也是交叉表引用的一个错误。与此同时,这里有一个解决方案:

    1.在源表中添加一个名为“Month”的列(您可以选择不同的名称)。

    2.使用MONTH公式从“Date Requested”列提取月号到“MONTH”列。

    3.在摘要表中,将COUNTIF公式更改为引用“Month”列,而不使用@cell

    这应该能暂时解决问题,直到我们解决@cell交叉表公式中的Bug。

    这将修复从源->摘要->仪表板的整个流程,并在源中添加新数据时自动更新所有流程。

    让我们知道这个临时解决方案是否适用于您。

    谢谢

    Sasan

  • Sasan,

    是的,这招奏效了。谢谢你和我一起走过这一步,我真的很感谢伟大的客户服务!

  • Sasan
    Sasan 员工

    快乐!谢谢你提出这个问题,这样我们就可以为所有其他可能使用的客户解决这个问题@cell在交叉表格公式中。

    Sasan

  • 你有什么约会吗@cell问题会解决吗?

    我也遇到了同样的问题。

    谢谢你!

@firestorm<\/a> <\/p>

Yes, unfortunately, (if I'm not mistaken) a license is needed to be able to edit a Dashboard. <\/p>

The sheet Owner and Admins can add or edit dashboard widgets. A license is required.<\/em><\/p>

More info. <\/p>

\n \n https:\/\/help.smartsheet.com\/articles\/518558-widget-types-for-smartsheet-dashboards\n <\/a>\n<\/div>


<\/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":292,"urlcode":"Dashboards","name":"Dashboards"}]},{"discussionID":106217,"type":"question","name":"Dynamic View- using multiple contact columns to restrict access","excerpt":"I have a dynamic view that used to give access based on two columns (if you were in the Contact or Back Up Contact - you could see that row). On Tuesday this functionality was no longer working (the page would not load for anyone) and I went in to fix it and had to select the restriction just on one contact column- I…","categoryID":321,"dateInserted":"2023-06-08T17:25:00+00:00","dateUpdated":null,"dateLastComment":"2023-06-11T20:19:14+00:00","insertUserID":135050,"insertUser":{"userID":135050,"name":"Kernesa Samana","url":"https:\/\/community.smartsheet.com\/profile\/Kernesa%20Samana","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HhtBX2V_lvQ!ujlE5-cskro!7uS1l0rsYem","dateLastActive":"2023-06-08T18:29:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":148510,"lastUser":{"userID":148510,"name":"CWS_Bob","url":"https:\/\/community.smartsheet.com\/profile\/CWS_Bob","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-11T20:38:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":57,"score":null,"hot":3372762854,"url":"https:\/\/community.smartsheet.com\/discussion\/106217\/dynamic-view-using-multiple-contact-columns-to-restrict-access","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106217\/dynamic-view-using-multiple-contact-columns-to-restrict-access","format":"Rich","lastPost":{"discussionID":106217,"commentID":380013,"name":"Re: Dynamic View- using multiple contact columns to restrict access","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380013#Comment_380013","dateInserted":"2023-06-11T20:19:14+00:00","insertUserID":148510,"insertUser":{"userID":148510,"name":"CWS_Bob","url":"https:\/\/community.smartsheet.com\/profile\/CWS_Bob","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-11T20:38: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-08T18:33:36+00:00","dateAnswered":"2023-06-08T18:04:40+00:00","acceptedAnswers":[{"commentID":379680,"body":"

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":106269,"type":"question","name":"Organizing Smartsheets into folders - Impact to DVs and WorkApps","excerpt":"Hello, I'm trying to organize the workspace listing in Smartsheet. If I create folders and move sheets into different folders, will that mess anything up for the Dynamic Views and WorkApp? Thanks, Frank","categoryID":321,"dateInserted":"2023-06-09T14:20:40+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T15:35:26+00:00","insertUserID":158554,"insertUser":{"userID":158554,"name":"Frank B.","url":"https:\/\/community.smartsheet.com\/profile\/Frank%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3HVYSSRAF5R9\/n9CDGKLAHBDUI.png","dateLastActive":"2023-06-09T15:34:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":116407,"lastUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-11T21:53:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":30,"score":null,"hot":3372645966,"url":"https:\/\/community.smartsheet.com\/discussion\/106269\/organizing-smartsheets-into-folders-impact-to-dvs-and-workapps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106269\/organizing-smartsheets-into-folders-impact-to-dvs-and-workapps","format":"Rich","tagIDs":[371,443],"lastPost":{"discussionID":106269,"commentID":379859,"name":"Re: Organizing Smartsheets into folders - Impact to DVs and WorkApps","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379859#Comment_379859","dateInserted":"2023-06-09T15:35:26+00:00","insertUserID":116407,"insertUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-11T21:53:40+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-09T15:36:14+00:00","dateAnswered":"2023-06-09T15:35:26+00:00","acceptedAnswers":[{"commentID":379859,"body":"

@Frank B.<\/a> If the folders are in the same Workspace that the sheets currently reside, there will for sure be no impact.<\/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":371,"urlcode":"WorkApps","name":"WorkApps"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势