var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Graphing data that 'isn't there'
I'm graphing a set of data from month to month, but for one month there is no data, and the chart is showing a value of -1. I'm wondering if there's a way to graph that as 100% instead of -1 %.
I'm using the percentage line graph using a couple running totals from the report.
Im thinking that another alternative would be to have my running total field to be 1 if it's 0 - so instead of displaying 0 it would display 1. This would solve my issue, but is there a way to do it?
Your solution sounds right. I would suggest creating a new formula which is the one you display on the graph. Its formula would be
If YourRunningTotal = 0 Then 1 Else YourRunningTotal