I'm using RSUM to tally up daily ticket sales.
But where there is a blank cell in the data table (because there were no sales that day) it leaves a blank datapoint on the chart as below. Anyone got a fix for this?
Hi Simon,
Here's the latest and greatest widget-level script for that...
widget.on('processresult', function(se, ev){ $.each(ev.result.series, function(seriesIndex, seriesValue){ var prevValue = seriesValue.data[0].y; $.each(seriesValue.data, function(index, value){ if(value.y == null) value.y = prevValue; else prevValue = value.y; }); });}); widget.on('render', function(sender,se){ for (var i = 0; i < sender.queryResult.series.length; i++ ) { for (var j = 0; j < sender.queryResult.series[i].data.length; j++) { sender.queryResult.series[i].data[j].marker.enabled = false; } }});
And here's how to apply it to the widget...
(+) Analytics Scripts not Saving - Wiki - analytic Coffee! - Tessitura Community
Thank you! My Area chart with dates with no sales looks much better now.Before:After: