显示金额和%的仪表板图表

托尼Fronza
托尼Fronza ✭✭
在内容基本知识

我们创建了一个仪表板，其中包括来自工作表摘要报告的图表。然而，虽然总记录是正确的，但百分比不是(例如，第一次会议的总数是67，但它显示的是47%，这是不准确的-它实际上是总数的12%)。因此，我创建了另一个摘要字段来计算正确的%(这是可行的，但随后仪表板显示12%和47%)。有人能解释一下为什么会这样吗?如果我们能做些什么来纠正这个问题呢?谢谢你！

截图#1 -使用%

image.png

截图#2 -使用金额(以%表示)

image.png


标签:
· 在Facebook上分享 在Twitter上分享

最佳答案

  • 瑞安国
    瑞安国 ✭✭✭✭✭✭
    ✓回答

    @Tony Fronza

    嘿,托尼。%的计算是基于半饼图中显示的数字来驱动的。

    因此，将第一次会议完成+中小企业跟进+发布提案算出总数。然后将总数除以每一项，得到百分比。

    你想要显示的正确信息是什么?这些数据/计数是如何在你的表格中表示的?

    瑞安国

    为初学者和高级智能表提示和技巧LinkedIn和YouTube

    过来打个招呼!

    · 在Facebook上分享 在Twitter上分享

答案

类别

Hi,<\/p>


<\/p>

You can send notifications to any valid email address. If you're planning to send alerts or reminders with a link to the sheet, the user will not be able to click the link and access it if they do not have a Smartsheet account and not shared to the sheet.<\/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":106482,"type":"question","name":"Smartsheet Bridge","excerpt":"Hi, I'm on Enterprise Plan and I'm trying to use Bridge but cannot log in to it. I actually had to dig the login link from the forums because I could not find it anywhere else, and when I try to sign in using my Smartsheet account it says \"Unable to log in with Smartsheet credentials at this time, try using Bridge…","categoryID":321,"dateInserted":"2023-06-15T08:35:55+00:00","dateUpdated":"2023-06-15T08:38:14+00:00","dateLastComment":"2023-06-16T08:51:39+00:00","insertUserID":149908,"insertUser":{"userID":149908,"name":"orad","url":"https:\/\/community.smartsheet.com\/profile\/orad","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pDFQaXDtqPs!u9_Rl3ztpP0!b22gvzMblTD","dateLastActive":"2023-06-18T01:37:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":149908,"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-17T21:03:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":40,"score":null,"hot":3373725454,"url":"https:\/\/community.smartsheet.com\/discussion\/106482\/smartsheet-bridge","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106482\/smartsheet-bridge","format":"Rich","tagIDs":[369,448],"lastPost":{"discussionID":106482,"commentID":380976,"name":"Re: Smartsheet Bridge","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380976#Comment_380976","dateInserted":"2023-06-16T08:51:39+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-17T21:03:00+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-16T04:53:08+00:00","dateAnswered":"2023-06-15T09:36:11+00:00","acceptedAnswers":[{"commentID":380710,"body":"

Hi @orad<\/a> <\/p>

I hope you're well and safe!<\/p>

Bridge is a Premium Add-on\/app that needs to be acquired separately. It's not included with the Enterprise license.<\/p>

Here's a possible workaround or workarounds <\/strong><\/p>

I recently developed an SMS solution for a client using 3rd-party services, Zapier and Twilio.<\/p>

Is that an option?<\/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":369,"urlcode":"bridge-by-smartsheet","name":"Bridge"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]},{"discussionID":106462,"type":"question","name":"Why do i need \"admin approval\" to use the smartsheet app in teams?","excerpt":"I'm trying to add a Smartsheet to a teams channel as a tab and I get the error: Admin approval needed. Smarsheet needs admin approval to enable channel level sharing for this app. You may continue without this feature, or, if you're an admin you may use the button below to grant approval. But hitting the \"grant…","categoryID":321,"dateInserted":"2023-06-14T20:14:51+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T20:43:43+00:00","insertUserID":161989,"insertUser":{"userID":161989,"name":"PGoodwin86","title":"Sr. Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/PGoodwin86","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T20:41:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161989,"lastUser":{"userID":161989,"name":"PGoodwin86","title":"Sr. Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/PGoodwin86","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T20:41:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":43,"score":null,"hot":3373550314,"url":"https:\/\/community.smartsheet.com\/discussion\/106462\/why-do-i-need-admin-approval-to-use-the-smartsheet-app-in-teams","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106462\/why-do-i-need-admin-approval-to-use-the-smartsheet-app-in-teams","format":"Rich","lastPost":{"discussionID":106462,"commentID":380649,"name":"Re: Why do i need \"admin approval\" to use the smartsheet app in teams?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380649#Comment_380649","dateInserted":"2023-06-14T20:43:43+00:00","insertUserID":161989,"insertUser":{"userID":161989,"name":"PGoodwin86","title":"Sr. Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/PGoodwin86","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T20:41:48+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-14T20:42:10+00:00","dateAnswered":"2023-06-14T20:41:29+00:00","acceptedAnswers":[{"commentID":380647,"body":"

You will have to get an admin of Teams to allow the Smartsheet for Teams app in the admin console of Teams.<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5380,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势

  • 自动化和电子邮件收件人

    您好，通过自动化标准发送的电子邮件通知是否仅对拥有Smartsheet帐户的收件人或在收件人字段中输入电子邮件地址的任何人可用?谢谢你！

  • 内容的桥梁

    嗨，我在企业计划，我试图使用桥，但无法登录到它。我实际上不得不从论坛上挖掘登录链接，因为我在其他任何地方都找不到它，当我尝试使用我的Smartsheet帐户登录时，它说“此时无法使用Smartsheet凭据登录，请尝试使用Bridge…

  • 为什么我需要“管理员批准”才能在团队中使用智能表单应用程序?

    我试图将智能表添加到团队频道作为选项卡，我得到错误:需要管理批准。Smarsheet需要管理员批准才能启用此应用程序的通道级共享。您可以在没有此功能的情况下继续，或者，如果您是管理员，您可以使用下面的按钮授予批准。但是点击“grant……”