I have several half-donut charts that show a goal progression that are reflecting correctly. Two of the charts are not reflecting the correct percentages of completion. What am I doing wrong?
Are you able to provide screenshots of the source data?
Hi @Kristin Fortner
I agree that it would be helpful to see the source data as well!
Based on your images, it looks like your widget is configured to show "Percent" versus showing "Value". What this does is it reads your values and compares them to create a percent.
However in your instance, it looks like your values are percents themselves. You'll want to ensure that when you combine the two values together it = 100:
It looks like perhaps the formula that's calculating the "% remaining" in your source may be giving you an incorrect remaining value.
Here is the data source
How are you getting the "% Remaining"? Are you subtracting the linked value from the Goal?
Currently the Grand Total actually equals 109% (36% + 73%) not 100% (which would be 36% + 64%)
I was averaging the other percent completes. Thank you! I think it's fixed now.
Glad to hear it's working now! 🙂
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.