475115_en-US

liliconcom

Carry Forward - Replace Missing Values

Replace missing values for desired columns with one click by carrying forward and holding the previous value.

 

This sometimes makes the subsequent analysis (e.g., Tabulate) and visualization of the data more understandable as opposed to dealing with lots of missing values that could merely mean a measurement was not made for the corresponding timestamp. In such cases carrying forward the previous value might very well be a viable choice compared to statistical approaches for missing value imputation.

 

Have a look at the short description video.

Data VisualizationUtilitiesRe: Carry Forward - Replace Missing Values

Thank You Byron,

Very helpful hint.

Re: Carry Forward - Replace Missing Values

Thanks @mhammoud and @Byron_JMP .  

Re: Carry Forward - Replace Missing Values

There is a right click option to do this too.

Select the column, then right click in the data grid to get the option