Blox: Replace NaN:NaN:NaN with '-'

Hi BIQ ,

Hope this script works for you. Update the variables in the script as commented

 

widget.on('processresult', function(se, ev){
	
	let panelName = 'Region' //update your panel name here
	let textToRepalce = '$10.18M' //update value of text to be replaced
	let replaceWith = '-' //new value/text to be displayed
	
	$.each(ev.result, function(resultIndex, resultValue){
		$.each(resultValue, function(index, value){
			if(value.Panel == panelName && value.Text == textToRepalce){
				value.Text = replaceWith
			}
		})
		
	})

})

-Hari