对报告摘要和分组的改进
可以改进报告摘要和分组的一些事情:
- 能够格式化汇总数据(IE为$ format)
- 按联系人列分组
- 将汇总数据作为指标拉到仪表板中
谢谢!
标签:
评论
-
萨拉·坎贝尔 ✭✭✭✭
是的-并且能够控制列布局一旦分组-主列卡功能是令人沮丧的在许多情况下。
-
彼得Spung ✭✭
是的和-能够分组和总结计数和总数的百分比。想象一下,如果……在the attached, mocked up an existing count by group report to include percent of total.
当然，我们需要能够控制小数位数，如果总数的百分比在同一列或其他列，如果是同一列，计数的顺序和总数的百分比，等等。
-
Cleversheet ✭✭✭✭✭✭@Peter Spung我可以预见这样一种情况，使用过滤器可能导致百分比总数加起来不等于100%。我想知道新选项是否改为标题为“显示总数的百分比”?或者这应该是一个附加选项而不是替代选项?
-
Cleversheet ✭✭✭✭✭✭
@TMarquardt我喜欢你所有的想法。
为了实现以美元格式显示[Summary Field]#——在它们属于的地方加上逗号——我不得不做一个多阶段的工作(这需要添加一个“假的”小十进制值)，并涉及一个非常复杂的公式。
(如果有兴趣了解我是如何做到这一点的，请联系我。)
-
艾丽卡L。 ✭✭✭
是的，如果我们可以在源表的同一列是多选择时，按分配给列分组报告，那就太好了!谢谢你！
-
沃伦·D ✭✭
这些特性加1分，特别是使用摘要报告作为仪表板上小部件的数据源。
此外，我希望能够向摘要报告添加新的非汇总表列，以增加汇总表字段。
我们希望让每个人都能灵活地使用工作表，但是我们有一组一致的汇总工作表字段，我们可以在汇总报告中汇总，然后将其用作仪表板的数据源，但是我们不能添加新列，除非它们已经存在于汇总工作表中。谢谢!
类别
2023-05-10T06:06:03.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":106267,"type":"idea","name":"Have Smartsheet auto include a generated PDF in the notification email","excerpt":"Hello! Is there way to have Smartsheet auto include a generated PDF in the notification email it sends out once a form is filled out and submitted? I'm still relatively new to Smartsheet and I currently have the automation set up to generate a document with each form submission and send an email to a specified email…","categoryID":349,"dateInserted":"2023-06-09T14:04:36+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T16:14:01+00:00","insertUserID":155580,"insertUser":{"userID":155580,"name":"Emilie","url":"https:\/\/community.smartsheet.com\/profile\/Emilie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:07:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":155580,"lastUser":{"userID":155580,"name":"Emilie","url":"https:\/\/community.smartsheet.com\/profile\/Emilie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:07:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":1,"hot":3372648217,"url":"https:\/\/community.smartsheet.com\/discussion\/106267\/have-smartsheet-auto-include-a-generated-pdf-in-the-notification-email","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106267\/have-smartsheet-auto-include-a-generated-pdf-in-the-notification-email","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106267,"commentID":379879,"name":"Re: Have Smartsheet auto include a generated PDF in the notification email","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379879#Comment_379879","dateInserted":"2023-06-09T16:14:01+00:00","insertUserID":155580,"insertUser":{"userID":155580,"name":"Emilie","url":"https:\/\/community.smartsheet.com\/profile\/Emilie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:07:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106207,"type":"idea","name":"Resize Image on Forms","excerpt":"Allow user to increase size of image on forms so that logos are more prominent and easier to read","categoryID":349,"dateInserted":"2023-06-08T15:24:27+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T19:39:23+00:00","insertUserID":162201,"insertUser":{"userID":162201,"name":"ritacoleHOPCo","title":"VP, IT Program Management","url":"https:\/\/community.smartsheet.com\/profile\/ritacoleHOPCo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T21:36:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":133951,"lastUser":{"userID":133951,"name":"Joe Goetschel","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Goetschel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QWNBAGYJ8LJG\/nJ2RMSJBMAY4K.jpg","dateLastActive":"2023-06-09T20:09:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":14,"score":2,"hot":3372578630,"url":"https:\/\/community.smartsheet.com\/discussion\/106207\/resize-image-on-forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106207\/resize-image-on-forms","format":"Rich","tagIDs":[204,363],"lastPost":{"discussionID":106207,"commentID":379923,"name":"Re: Resize Image on Forms","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379923#Comment_379923","dateInserted":"2023-06-09T19:39:23+00:00","insertUserID":133951,"insertUser":{"userID":133951,"name":"Joe Goetschel","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Goetschel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QWNBAGYJ8LJG\/nJ2RMSJBMAY4K.jpg","dateLastActive":"2023-06-09T20:09:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106138,"type":"idea","name":"Add Attachments to Alerts in general (not the ones on the row)","excerpt":"Please allow the addition of attachments that are not associated with a row. For example, when an alert is triggered, an email is sent and I would be able to attach an instruction sheet or welcome letter to the alert. Right now the options for doing this are either too limiting, cumbersome, or confusing for those who are…","categoryID":349,"dateInserted":"2023-06-07T15:09:08+00:00","dateUpdated":"2023-06-07T15:12:39+00:00","dateLastComment":"2023-06-08T18:41:51+00:00","insertUserID":161995,"insertUser":{"userID":161995,"name":"phillipo","title":"HR Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/phillipo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T15:01:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":103241,"lastUser":{"userID":103241,"name":"Autumn Beauchamp","url":"https:\/\/community.smartsheet.com\/profile\/Autumn%20Beauchamp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T18:05:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":36,"score":3,"hot":3372402959,"url":"https:\/\/community.smartsheet.com\/discussion\/106138\/add-attachments-to-alerts-in-general-not-the-ones-on-the-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106138\/add-attachments-to-alerts-in-general-not-the-ones-on-the-row","format":"Rich","tagIDs":[268,363],"lastPost":{"discussionID":106138,"commentID":379688,"name":"Re: Add Attachments to Alerts in general (not the ones on the row)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379688#Comment_379688","dateInserted":"2023-06-08T18:41:51+00:00","insertUserID":103241,"insertUser":{"userID":103241,"name":"Autumn Beauchamp","url":"https:\/\/community.smartsheet.com\/profile\/Autumn%20Beauchamp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T18:05:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":3}],"tags":[{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]}],"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
