饼图bug?每个系列都是一个[未命名的系列]?

spencerthayer
编辑04/29/22 内容基本知识

为什么这个饼状图坏了?什么是[未命名系列]?应该以“执行团队”和“垂直建设”为系列。

截屏时间:2016-04-28下午6点16分

这个漏洞自2018年以来一直存在,似乎没有任何解决方案。

我该如何解决这个问题?

答案

  • 为了获得有意义的饼图数据,我是否需要通过API导出我的工作表,用PHP处理它,然后通过web嵌入饼图?这似乎很可笑。

  • 凯文•史密斯
    凯文•史密斯 ✭✭✭✭✭✭

    当您第一次添加图表小部件时,您应该看到使用第一列作为系列标签的选项。看看它是否打开并检查了。

    image.png

    请让我知道,如果它检查,你仍然没有看到这个系列。

    谢谢你!

    凯文

    如果可以,我很乐意帮忙。

    ☑️你对我对你问题的回答满意吗?请帮助社区将其标记为接受的回答)

added to shared workspace?","excerpt":"I have created a group called 'Coding organizers' and added 3 members in this: myself Dirk John I have then shared a workspace called 'Coding test' with the group. Now all 3 of us have access to the workspace. What if a new contact\/member called Judith will be added to the group 'Coding organizers'. Will she automatically…","categoryID":321,"dateInserted":"2023-06-06T14:22:55+00:00","dateUpdated":"2023-06-06T14:27:55+00:00","dateLastComment":"2023-06-06T15:11:50+00:00","insertUserID":161267,"insertUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-06-07T07:22:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"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-06T19:28:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":32,"score":null,"hot":3372127485,"url":"https:\/\/community.smartsheet.com\/discussion\/106063\/adding-contacts-to-group-added-to-shared-workspace","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106063\/adding-contacts-to-group-added-to-shared-workspace","format":"Rich","tagIDs":[208,245,442],"lastPost":{"discussionID":106063,"commentID":379027,"name":"Re: Adding contacts to Group --> added to shared workspace?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379027#Comment_379027","dateInserted":"2023-06-06T15:11:50+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-06T19:28: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-06T14:50:49+00:00","dateAnswered":"2023-06-06T14:45:28+00:00","acceptedAnswers":[{"commentID":379014,"body":"

She will be shared to whatever workspaces the group has at the same permission level as the group.<\/p>


<\/p>

It also works in the opposite direction. If someone has access to a Smartsheet item through a group then they will no longer have access to that item if they are removed from the group unless they are shared as an individual back to the item.<\/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":208,"urlcode":"Workspaces","name":"Workspaces"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]},{"discussionID":106011,"type":"question","name":"Why do I get a #Incorrect argument set error with the formula below\/","excerpt":"=IF(Status@row = \"Not Started\", \"Blue\", IF(OR(AND(TODAY()>[End Date]@row, Status@row = \"Not Started\"), AND(TODAY()>[End Date]@row, Status@row = \"In Progress\")), \"Red\", IF(OR(AND(TODAY(-5)>[End Date]@row, Status@row = \"Not Started\"), AND(TODAY(-5)>[End Date]@row, Status@row = \"In Progress\")), \"Yellow\", IF(Status@row =…","categoryID":321,"dateInserted":"2023-06-05T15:02:28+00:00","dateUpdated":null,"dateLastComment":"2023-06-05T15:26:32+00:00","insertUserID":159166,"insertUser":{"userID":159166,"name":"Carole M.","url":"https:\/\/community.smartsheet.com\/profile\/Carole%20M.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T17:00:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-07T03:48:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":44,"score":null,"hot":3371957940,"url":"https:\/\/community.smartsheet.com\/discussion\/106011\/why-do-i-get-a-incorrect-argument-set-error-with-the-formula-below","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106011\/why-do-i-get-a-incorrect-argument-set-error-with-the-formula-below","format":"Rich","lastPost":{"discussionID":106011,"commentID":378815,"name":"Re: Why do I get a #Incorrect argument set error with the formula below\/","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378815#Comment_378815","dateInserted":"2023-06-05T15:26:32+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-07T03:48:01+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-05T15:22:11+00:00","dateAnswered":"2023-06-05T15:14:09+00:00","acceptedAnswers":[{"commentID":378809,"body":"

14 opening parentheses, 15 closing parentheses.<\/p>"},{"commentID":378815,"body":"

It's an easy mistake to make. Glad I could help.<\/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":105939,"type":"question","name":"Admin Centre - multiple admins","excerpt":"Allow more than one user the ability to administer the admin centre. It is common for enterprise clients to have more than one administrator, therefore this creates bottlenecks in user management tasks, if that one user is busy or on annual leave.","categoryID":321,"dateInserted":"2023-06-02T10:50:44+00:00","dateUpdated":"2023-06-06T09:42:35+00:00","dateLastComment":"2023-06-06T09:48:22+00:00","insertUserID":139581,"insertUser":{"userID":139581,"name":"darkmatter","url":"https:\/\/community.smartsheet.com\/profile\/darkmatter","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!XHPS3zzuBP4!m3DRfwiLWvQ!vLAErbBT_f5","dateLastActive":"2023-06-06T09:47:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":139581,"lastUser":{"userID":139581,"name":"darkmatter","url":"https:\/\/community.smartsheet.com\/profile\/darkmatter","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!XHPS3zzuBP4!m3DRfwiLWvQ!vLAErbBT_f5","dateLastActive":"2023-06-06T09:47:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":43,"score":1,"hot":3371750646,"url":"https:\/\/community.smartsheet.com\/discussion\/105939\/admin-centre-multiple-admins","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105939\/admin-centre-multiple-admins","format":"Rich","lastPost":{"discussionID":105939,"commentID":378949,"name":"Re: Admin Centre - multiple admins","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378949#Comment_378949","dateInserted":"2023-06-06T09:48:22+00:00","insertUserID":139581,"insertUser":{"userID":139581,"name":"darkmatter","url":"https:\/\/community.smartsheet.com\/profile\/darkmatter","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!XHPS3zzuBP4!m3DRfwiLWvQ!vLAErbBT_f5","dateLastActive":"2023-06-06T09:47:38+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-06T09:47:55+00:00","dateAnswered":"2023-06-06T09:42:13+00:00","acceptedAnswers":[{"commentID":378948,"body":"

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

Thank you for clarifying! It sounds like you request has to do with Group Admins (versus System Admins).<\/p>

Please feel free to add your comment and vote to this other Idea post on the same topic: Multiple Owners to add users to Smartsheet Groups<\/a><\/p>

Note that System Admins can also add members to Groups, in addition to the main Group Owner. Here's more information. <\/a><\/p>

Cheers,<\/p>

Genevieve<\/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":1},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势