I'm trying to build a line chart that tracks cumulative performance revenue by order date. I've noticed in our environment that if there are periods where there were no sales, Tess Analytics does not continue to draw the line, instead it breaks down into smaller dashes and dots. Has anyone else experienced this? Is this part of how the sisense software works, or is there something else to look into? Thanks!
For reference:
Hi Daniel,
Yes, using that script, points on the original line that are isolated, single data-points not immediately preceded or followed by another non-null data-point of the x-axis, a marker dot will still be rendered on the line chart:
Expanding this script, we can iterate through all series lines, and all data points on each line to explicitly remove the marker dots. This will remove the markers as shown below, however, any series with only one data-point in the whole widget will disappear from the chart altogether. This may be a non-issue in your data however.
//The top script will connect the dashed parts like the top yellow line pictured above
widget.on("beforeviewloaded",function(scope, args){
args.options.plotOptions.series.connectNulls = true;
});
//Turns off the markers
widget.on('render', function(sender,se){
for
(var i = 0; i < sender.queryResult.series.length; i++ ) {
(var j = 0; j < sender.queryResult.series[i].data.length; j++) {
sender.queryResult.series[i].data[j].marker.enabled = false;
}
)
View online
You find that info linked handily in the analytic Coffee! wiki here https://community.tessituranetwork.com/topical_groups/analytics-coffee/w/wiki/793/removing-data-markers-for-isolated-single-data-points