Forum Discussion

Anonymous's avatar
Anonymous
03-04-2022

Display values continuously over time with existing gaps in FACT data table

Hi All, I have the following use case: I want to visualize the overall stock level of 2 different products over time. The source for the stock levels is a FACT table containing the log data of the ...
dashboards & reporting
Data Models
Retail
harikm007's avatar
harikm007
Data Warehouse
03-04-2022

Anonymous 

Please check if this script works for you

widget.on('processresult', function(se, ev){
	
	$.each(ev.result.series, function(index, value){
		
		var prevValue = -1
		
		$.each(value.data, function(dataindex, datavalue){

			if(dataindex == 0)
				prevValue = datavalue.y
			else
			{
				if(!datavalue.y)
					datavalue.y = prevValue
				else
					prevValue = datavalue.y
			}	
		})
	})
})

-Hari