RSUM with Display Missing as Zero and BreakBy

[wallingfordce]

I got ahead of the user on this one...

Solved: RSUM with Display Missing as Zero - Sisense Community

...and found out only after getting a great solution that the user has a field in the Break By. Anyone gracious who can expand the script to work over the break by?

[harikm007 · Accepted solution]

Hi @wallingfordce ,

Try this script:

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	
		})
	
	})	

})

-Hari