Sign in to submit new ideas and vote
Get Started

Retain dashboard widget colors after selecting new data

图表小部件一旦你做出新的选择ges for the data on a ‘Chart’ widget, it will return to the original system color. The result may be sloppy, with two data series having the same color! Consider changing the behavior so that it doesn't default to the original scheme. Instead, it should retain the color selections I've made in the past and if needed, assign a new color to new data.

Tags:
8
8 votes

Available Now!·Last Updated

Good news! Your dashboard chart colors will now persist based on the color mapping you set when a chart is created or modified. Please note that colors need to be reselected and saved for the persistence to take effect for existing charts.

Comments

  • Sarah123
    Sarah123 ✭✭✭
    edited 02/23/23

    I have a few templates that include dashboards with charts and I'd like to have specific status' have specific colors. Right now I have to enter in fake data to have the colors stick but this causes confusion when people use the templates and don't update the statuses from the fake data. It would be VERY useful to be able to set default colors for a template or even a workspace (even one that would look at if the data matches this text then this color should be used).

  • Sarah123
    Sarah123 ✭✭✭

    @Genevieve P.How can I save the colors for items that are not set in the series? Can I somehow enter in an item so that if/when it appears it will be a specific color? For example tasks by status; if it's not started have this color and in progress have this color, etc. I don't see an option to do that in the template we have. Thanks.

  • Genevieve P.
    Genevieve P. Employee Admin
    edited 04/06/23

    Hi@Sarah123

    Can you clarify what chart type you're using?

    Screenshot 2023-04-06 at 15.09.09.png


    If you're using a Pie Chart and the values are 0 they won't show up to assign a colour.




    Screenshot 2023-04-06 at 15.07.25.png


    However you could switch the chart type to be something else (e.g. a Bar Chart) and assign a colour.

    Then change it back to a Pie Chart and Save the Dashboard.




    This should then bring up the correct colour for future data!

    Screenshot 2023-04-06 at 15.07.47.png


    Screenshot 2023-04-06 at 15.07.57.png





    Let me know if that makes sense and works for you.

    Cheers,

    Genevieve

  • Sarah123
    Sarah123 ✭✭✭

    谢谢吉纳维芙!我们using a donut chart and don't have the data entered until a status is changed for a task. Unfortunately, I tested this by doing the workaround in the project template and it didn't keep the colors I had setup when a new project was created using control center. It still selected colors on it's own. Is it possible to reopen this issue so that we can setup templates for specific colors for items? Thank you.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@Sarah123

    The initial release was rolled back to fix a few elements before making it live again - the status on this thread has been updated to "Coming Soon" and when this is fixed it will be changed to "Available Now".

  • Genevieve P.
    Genevieve P. Employee Admin

    Hey@Sarah123,

    This release is now available again! Please test it out and let us know if you have any further feedback.

    Cheers,

    Genevieve

  • Josh Reed
    Josh Reed ✭✭✭✭✭

    Nice I'll be looking into this. I have various dashboards with tons of metric calculations... often many datapoints temporarily fall to 0 on my pie/donuts and then come back as whatever color it wants. I wonder if this fix would work... just set everything up as a bar chart first and save, then convert to pie.

2023-05-29T14:42:11.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":107060,"type":"idea","name":"Tabbing through \"pages\" in form","excerpt":"When having clients\/customers\/employees fill out a form, it would be helpful to break the form down into \"pages\". This would allow the breakout of specific data sets from other information being collected.","snippet":"When having clients\/customers\/employees fill out a form, it would be helpful to break the form down into \"pages\". This would allow the breakout of specific data sets from other…","categoryID":349,"dateInserted":"2023-06-28T21:15:07+00:00","dateUpdated":"2023-06-28T21:15:23+00:00","dateLastComment":"2023-06-28T21:15:07+00:00","insertUserID":80376,"insertUser":{"userID":80376,"name":"brandi.meyer80376","url":"https:\/\/community.smartsheet.com\/profile\/brandi.meyer80376","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-29T11:48:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":80376,"lastUserID":80376,"lastUser":{"userID":80376,"name":"brandi.meyer80376","url":"https:\/\/community.smartsheet.com\/profile\/brandi.meyer80376","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-29T11:48:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":21,"score":3,"hot":3375974730,"url":"https:\/\/community.smartsheet.com\/discussion\/107060\/tabbing-through-pages-in-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107060\/tabbing-through-pages-in-form","format":"Rich","tagIDs":[204,363],"lastPost":{"discussionID":107060,"name":"Tabbing through \"pages\" in form","url":"https:\/\/community.smartsheet.com\/discussion\/107060\/tabbing-through-pages-in-form","dateInserted":"2023-06-28T21:15:07+00:00","insertUserID":80376,"insertUser":{"userID":80376,"name":"brandi.meyer80376","url":"https:\/\/community.smartsheet.com\/profile\/brandi.meyer80376","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-29T11:48:54+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":204,"urlcode":"Forms","name":"Forms"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":107003,"type":"idea","name":"Job Posting Area","excerpt":"It would be a good idea to have a \"job postings\" space for Smartsheet experts. I say this because I often need support and it's hard to find someone who knows Smartsheet and is available to do some specific work. And we have this community that brings together a series of SS users.","snippet":"It would be a good idea to have a \"job postings\" space for Smartsheet experts. I say this because I often need support and it's hard to find someone who knows Smartsheet and is…","categoryID":348,"dateInserted":"2023-06-28T10:17:53+00:00","dateUpdated":"2023-06-28T10:27:01+00:00","dateLastComment":"2023-06-28T13:49:52+00:00","insertUserID":151785,"insertUser":{"userID":151785,"name":"Paulo Ferrer","url":"https:\/\/community.smartsheet.com\/profile\/Paulo%20Ferrer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!xHt0MTLRKzo!7BFre1PPR_s!sorTBWD2G3D","dateLastActive":"2023-06-28T10:19:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"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-29T13:44:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":41,"score":3,"hot":3375909765,"url":"https:\/\/community.smartsheet.com\/discussion\/107003\/job-posting-area","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107003\/job-posting-area","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":107003,"commentID":382832,"name":"Re: Job Posting Area","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382832#Comment_382832","dateInserted":"2023-06-28T13:49:52+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-29T13:44: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":"Community Platform Feedback","url":"https:\/\/community.smartsheet.com\/categories\/community-platform-feedback"}],"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":348,"name":"Community Platform Feedback","url":"https:\/\/community.smartsheet.com\/categories\/community-platform-feedback","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":3}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106988,"type":"idea","name":"Resource Management: Clear Suggestions - Ability to turn this feature off.","excerpt":"In resource management, It would be great to have the ability to turn the suggested hrs off. Ideally at a project level. For some teams it may be useful, however for others its a burden as the allocations are mostly incorrect. If someone is across more than one project, e.g. working on \"client A\" Mon + Tue (40%) and…","snippet":"In resource management, It would be great to have the ability to turn the suggested hrs off. Ideally at a project level. For some teams it may be useful, however for others its a…","categoryID":349,"dateInserted":"2023-06-28T00:30:37+00:00","dateUpdated":"2023-06-28T09:28:23+00:00","dateLastComment":"2023-06-28T00:30:37+00:00","insertUserID":162520,"insertUser":{"userID":162520,"name":"gvattura","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/gvattura","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T00:30:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":162520,"lastUser":{"userID":162520,"name":"gvattura","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/gvattura","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T00:30:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":21,"score":2,"hot":3375857340,"url":"https:\/\/community.smartsheet.com\/discussion\/106988\/resource-management-clear-suggestions-ability-to-turn-this-feature-off","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106988\/resource-management-clear-suggestions-ability-to-turn-this-feature-off","format":"Rich","tagIDs":[363,468],"lastPost":{"discussionID":106988,"name":"Resource Management: Clear Suggestions - Ability to turn this feature off.","url":"https:\/\/community.smartsheet.com\/discussion\/106988\/resource-management-clear-suggestions-ability-to-turn-this-feature-off","dateInserted":"2023-06-28T00:30:37+00:00","insertUserID":162520,"insertUser":{"userID":162520,"name":"gvattura","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/gvattura","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T00:30:40+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":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":468,"urlcode":"resource-management","name":"Resource Management"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-05-29T14%3A42%3A11%2B00%3A00&type%5B0%5D=Idea&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":156,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">