Why can't I graph a single percentage of 0% from a report in Smartsheets?

Joel Turlington

When I choose Select Column in the graph widget, the graphing works fine if 1) there are multiple Percentages and/or 2) the cell has anything but 0% in it.  I need to be able to graph ONE percentage even if that percentage is zero.  Smartsheets is telling me it cannot graph the data and to use a different column?  If the percentage is anything but zero it graphs it perfectly fine. 

Thanks!

Genevieve P.

Hi Joel,

As you have found, Pie and Donut charts are unable to display 0% if this is the only data selected - please submit an Enhancement Request when you have a moment!

If you're looking to display the percentage from one cell, what about using a Metric widget instead?

Cheers,

Genevieve

Genevieve P.

Hi Joel,

As you have found, Pie and Donut charts are unable to display 0% if this is the only data selected - please submit an Enhancement Request when you have a moment!

If you're looking to display the percentage from one cell, what about using a Metric widget instead?

Cheers,

Genevieve

Joel Turlington

Well as far as I can tell you can't display 0% on a bar graph either unless you have more than one metric.  I can't use the metric widget because I have 40 other customers charted with bar graphs and that's the way the boss wants its.  This is going to be viewed by executive and senior management and has to be consistent across all customers.  Submitting Enhancement request. 

Genevieve P.

I was able to input a bar graph with the value as 0% - it just shows up as a blank chart.

Could you maybe try "tricking" the widget? Change the cell to 1%, add the chart widget, then go back and update the source sheet back to 0%. Did that work?

Joel Turlington

Yea I tried, it didn't work.  I greatly appreciate your assistance!  I have submitted a performance enhancement for this functionality.   :)

SBoyle

I am reviewing this software and my organization is considering it but we just happened upon this very issue. We want to create a dashboard with pie charts but some values are at zero and wont chart in any format. Seems like such a basic basic issue. Will this be resolved soon? Where is it on the Roadmap? I can't believe it has been two years as a known issue and it is not resolved.