图表轴定制
答案
-
拉姆齐扎基 ✭✭✭✭✭✭
具有缩放图表的能力,使类似的数据处于相同的比例是至关重要的。我的高管们已经不再使用我们的仪表板,因为所传达的数据具有误导性,除非有人真正关注底部的规模。
-
玛克辛罗伯茨 ✭✭✭✭
我认为这需要在下次发布的更新中优先考虑,因为似乎有很多人和我一样,现在发现仪表板中的图表由于自动缩放而不能正确描绘数据的故事。
-
同意所有……一个简单的0% - 100%条形图是一个非常需要的功能。
-
山姆·霍尔登 ✭
除此之外,我的公司也非常希望看到这种灵活性的变化发生。
-
下一个版本中是否会更新这个更改Axis比例的选项?如果没有,我就回到使用Excel,因为Smartsheet不能给我提供我需要的清晰准确的报告图像。
-
泰德马宏升 ✭
那么我们有一个确定的日期吗?我的新构建完成了95%,但由于某些原因,我的图表比例变成了120%。所以从5%变成了25%
-
泰德马宏升 ✭
另外,它是如何计算比例的?也许我们的答案就在那里。
-
泰德马宏升 ✭
乍一看,这个比例似乎与调整页面上窗口的大小有关。嗯。
-
汤姆·高尔 ✭
我也需要这个功能,似乎有相当多的用户认为这是一个关键功能。它在路线图上吗?
能够确保正确地解释信息的可视化表示是指示板的关键需求。添加这些类型的控制可能会导致Smartsheet的仪表板使用率显著上升。我真的不喜欢为了仪表板而回到excel,准确地解释视觉数据对仪表板的成功至关重要。
请考虑添加此功能和其他与轴相关的自定义。
-
尼克富恩特斯 ✭✭✭✭✭
仪表盘上浪费了太多空间。我觉得“最高价是图表顶部”按钮至少不会很难执行。有人要求我把堆叠的图表做得更高,以弥补丢失的英寸,但这只会导致更多的空间浪费。来吧,智能表,这个帖子开始于3年前,它仍然没有修复。
-
布兰登·R。 员工
披露:我是一名Smartsheet支持代表
我可能已经找到了解决这个问题的方法,但是您可能需要根据您的具体需求对解决方案进行微调。
使用测试数据,我能够创建两个列。我在每个条目中都设置了与前一个条目相当接近的值,以确保图形对于范围来说不会太宽。
我对两列的数据进行了升序排序,如截图所示。从那里,我可以进入仪表板,看到数据是按照我在工作表中的排序方式进行排序的。
现在,由于有两组数据被排序,这就是为什么它被分开。但是,这也意味着图本身是按升序对数据排序的。
选择选项的第二个屏幕截图来自一个报告。这也适用于报表,因此您可以对一些值进行微调,但看起来我们可以获得一个近乎完美的排序选项,至少在将值设置为首先按所需的主列排序,然后再按所需的其他列排序方面是这样。
我建议使用带有图表小部件的报表,因为这将允许您在一个位置使用多个工作表,并从那里创建排序规则。这可能需要一些尝试和错误,但这是我在没有实际排序选项的情况下所能找到的最接近的。
“疯狂就是一遍又一遍地做同样的事情,却期望得到不同的结果”——阿尔伯特·爱因斯坦
“聪明人从愚蠢的问题中学到的东西,比傻瓜从明智的回答中学到的东西要多。”——李小龙
-
只是再加一句评论,希望能有所改善。无法自定义轴的最大值和最小值确实令人沮丧,并给那些“Excel比Smartsheet好”的人提供了更多的能量。
-
SJ卖家 ✭✭✭
像其他人一样,我在这个帖子中添加了另一条评论,以将这个产品差距推到顶部。ob欧宝娱乐app手机下载
100%堆叠条形图和柱状图非常常见,任何基本软件都应该提供这种功能。
当图表的比例持续到120%时,读者必须停下来消化数据。这给我们的用户带来了问题@Matt Siglinger正确地指出了这一点——给了那些批评智能表的人氧气。
-
劳拉·巴特利特 ✭✭✭✭
我正在评论,因为我也喜欢这个功能。我们有一个堆叠条形图,其中有多个数字表示平均天数。由于是在本季度的早期,一个网站显示天数为0.05。因为这个数字,纵轴显示-10。
类别
Hi @mgreenwalt<\/a> <\/p> I hope you're well and safe!<\/p> Here's a possible workaround or workarounds <\/strong><\/p> Would any of those options work\/help? <\/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":446,"urlcode":"update-requests","name":"Update Requests"}]},{"discussionID":106397,"type":"question","name":"Line Item Signature Requests","excerpt":"I have a database of assets, and want to send each asset owner an automated form, which I can do, with their asset listing. What I need to receive is a \"signature\" that the assets are acknowledged. by the owner, and include verbiage that the asset owner agrees to abide by. I can create the form, automate it, but I have not…","categoryID":321,"dateInserted":"2023-06-13T20:39:57+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T14:00:24+00:00","insertUserID":162344,"insertUser":{"userID":162344,"name":"Pauline J","title":"Director of Operations\/IT","url":"https:\/\/community.smartsheet.com\/profile\/Pauline%20J","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T16:53:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-15T10:24:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":32,"score":null,"hot":3373443021,"url":"https:\/\/community.smartsheet.com\/discussion\/106397\/line-item-signature-requests","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106397\/line-item-signature-requests","format":"Rich","lastPost":{"discussionID":106397,"commentID":380488,"name":"Re: Line Item Signature Requests","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380488#Comment_380488","dateInserted":"2023-06-14T14:00:24+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-15T10:24: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":"2023-06-14T13:05:40+00:00","dateAnswered":"2023-06-13T22:18:29+00:00","acceptedAnswers":[{"commentID":380401,"body":" Hi @Pauline J<\/a> <\/p> I hope you're well and safe!<\/p> Here's a possible workaround or workarounds <\/strong><\/p> Would any of those options work\/help? <\/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>"},{"commentID":380454,"body":" @Pauline J<\/a> <\/p> Excellent!<\/p> Happy to help!<\/p> Here's an example of how it could look.<\/p>