Forum Discussion

strachi's avatar
strachi
Regular Visitor
8 years ago

Moving average over non-numeric values (correct errors, fill missing values)

Hi, how can I smooth string values in a column?   I have time series data (timestamp; string) with some errors or gaps in it:   timestamp;string 1521585642;a 1521585643;a 1521585644; 1521585...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi strachi,

 

Can you share a complete sample please? I can't convert the "timestamp" into a time or a date.

 

 

Best Regards,

Dale