在报表上折叠行
评论
-
斯蒂芬妮·泰勒 ✭✭✭✭✭✭我不这么认为。
-
Shaine格林伍德 员工报表不显示层次结构，因此无法折叠报表中的行。
我在我们的改进请求列表中得到了你的反对票，以供进一步考虑。
类别
Add an IFERROR<\/p>
=IFERROR(DATE(YEAR([Date Completed]@row) + 3, MONTH([Date Completed]@row), DAY([Date Completed]@row)), \"\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":485,"urlcode":"community-champions","name":"Community Champions"}]},{"discussionID":106206,"type":"question","name":"Pie Chart breaks when values are zero","excerpt":"In a dashboard, pie charts are breaks the reference and shows as Unable to display chart when reference values are changed to zero as these vales calculated via formula. Only Bar charts are showing as No data to display. My end goal is to show as No data to display when values are zero. Kindly help me out here.","categoryID":322,"dateInserted":"2023-06-08T15:21:25+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T18:01:33+00:00","insertUserID":162199,"insertUser":{"userID":162199,"name":"Gajapathi R M","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Gajapathi%20R%20M","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T17:37:33+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":"2023-06-08T18:05:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":24,"score":null,"hot":3372488578,"url":"https:\/\/community.smartsheet.com\/discussion\/106206\/pie-chart-breaks-when-values-are-zero","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106206\/pie-chart-breaks-when-values-are-zero","format":"Rich","tagIDs":[292],"lastPost":{"discussionID":106206,"commentID":379679,"name":"Re: Pie Chart breaks when values are zero","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379679#Comment_379679","dateInserted":"2023-06-08T18:01:33+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":"2023-06-08T18:05:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/7KSJLJBZG3GE\/only-bar-chart-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Only Bar Chart.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-08T17:37:29+00:00","dateAnswered":"2023-06-08T17:12:16+00:00","acceptedAnswers":[{"commentID":379665,"body":"
So is it a sheet that has the calculations on it or a row report? If it is a sheet then you can add 0.00001 to all calculations and decrease the shown decimals. This will maintain some data greater than zero but only display zero.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
