This node calculates the moving average of a column. The moving average values are displayed in a new column appended at the end of the table or (if selected) replaces the original columns. For all window based methods (Backward/Center/Forward simple/Gaussian, Harmonic Mean) the cells that do not have a complete window (at the beginning and the end of the table) are filled with Missing Values.
Options
Methods
Popular Successors
- Math Formula6 %
- Loop End3 %
Row Filter (deprecated)3 %- Moving Average3 %
Column Rename2 %- Sorter2 %
Excel Writer (XLS)2 %- Concatenate1 %
- Joiner1 %
- Line Plot (JavaScript)1 %
- Column Rename (Regex)1 %
- Lag Column1 %
- Number Rounder1 %
- Excel Writer1 %
- Date&Time Part Extractor1 %
- Loop End (Column Append)1 %
- Missing Value1 %
- Line Plot1 %
- Pivot1 %
- Line Plot (Plotly)1 %
- Scatter Plot (JavaScript)1 %
- Numeric Scorer< 1 %
- Column Filter< 1 %
- Column Renamer< 1 %
Column Appender< 1 %- Unpivot< 1 %
- R View (Table)< 1 %
- CSV Writer< 1 %
- GroupBy< 1 %
- Column Splitter< 1 %
Python View< 1 %Cell Splitter< 1 %Row Splitter (deprecated)< 1 %- Statistics< 1 %
- Interactive Pie chart (legacy)< 1 %
Python Script (1⇒1)< 1 %- R Snippet< 1 %
- Date&Time Difference< 1 %
- Extract Variables (Data)< 1 %
Loop End< 1 %- Scorer< 1 %
Number To String< 1 %- Column Resorter< 1 %
- RowID< 1 %
- Scatter Plot (legacy)< 1 %
- Color Manager< 1 %
- Math Formula (Variable)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Java Snippet (simple)< 1 %
- Date&Time-based Row Filter< 1 %
Recursive Loop End< 1 %Numeric Scorer< 1 %- Column Name Extractor< 1 %
- Double to Integer< 1 %
- Table Transposer< 1 %
- Single sample t-test< 1 %
- Scatter Plot< 1 %
- Stacked Area Chart (Plotly)< 1 %
- Column Expressions< 1 %
- Python Script (legacy)< 1 %
- Data to Report (BIRT)< 1 %
Extract Date&Time Fields< 1 %- Catch Errors (Data Ports)< 1 %
- Java Snippet< 1 %
- Group Loop Start< 1 %
- X-Partitioner< 1 %
- DBSCAN< 1 %
- Linear Regression Learner< 1 %
- Cell Splitter< 1 %
- Column Combiner< 1 %
- Number to String< 1 %
- Column Aggregator< 1 %
- Column Appender< 1 %
- Constant Value Column< 1 %
- Extract Missing Value Cause< 1 %
- Table Manipulator< 1 %
- Normalizer< 1 %
- Partitioning< 1 %
- String Manipulation< 1 %
- Rule-based Row Filter< 1 %
- Rule Engine< 1 %
- Rule-based Row Splitter< 1 %
- Line Plot (legacy)< 1 %
- ROC Curve (legacy)< 1 %
- Scatter Plot (Plotly)< 1 %
- Math Formula (Multi Column)< 1 %
- Line Chart (JFreeChart)< 1 %
- Google Sheets Updater< 1 %
- Table View (JavaScript)< 1 %
- Date&Time to legacy Date&Time< 1 %
- Date&Time Shift< 1 %
- Date/Time Shift (legacy)< 1 %
- Moving Aggregator< 1 %
- ARIMA Predictor< 1 %
- Regression Predictor< 1 %
- Domain Calculator< 1 %
- Scatter Matrix (legacy)< 1 %
Dictionary tagger< 1 %- Generic JavaScript View (JavaScript)< 1 %
- Kafka Producer< 1 %
- GET Request< 1 %
- String to Date&Time< 1 %
- Column List Loop Start< 1 %
Scorer< 1 %- Binner (Dictionary)< 1 %
- Correlation Filter< 1 %
- Value Counter< 1 %
- Rank Correlation< 1 %
- End IF< 1 %
- String to Date/Time (legacy)< 1 %
- Symmetry< 1 %
- Window Slider< 1 %
- 2D/3D Scatterplot< 1 %
- ARIMA Visualization< 1 %
CSV Writer< 1 %Table Writer< 1 %Interval Loop Start< 1 %- Decision Tree Predictor< 1 %
Linear Regression Learner< 1 %Regression Predictor< 1 %- Numeric Binner< 1 %
- Column Comparator< 1 %
- String to Number< 1 %
- Cross Joiner< 1 %
- Missing Value Column Filter< 1 %
- Reference Row Filter< 1 %
- Numeric Median Test< 1 %
- Histogram (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Counter Generation< 1 %
- Generic Web Service Client< 1 %
XLS Writer< 1 %Excel Sheet Appender (XLS)< 1 %- Send to Power BI< 1 %
- Java Snippet Row Filter< 1 %
- Python View (legacy)< 1 %
- Table to R< 1 %
- Date&Time to String< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Date Field Extractor (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- Welch Averaging< 1 %
- TIBCO Spotfire File Writer< 1 %
- Envelope Function< 1 %
- Outlier Removal< 1 %
- Convert to R< 1 %
- ARIMA Learner< 1 %
- Feature Selection Loop Start (1:1)< 1 %
Loop End (2 ports)< 1 %- Chunk Loop Start< 1 %
Recursive Loop Start< 1 %Naive Bayes Learner< 1 %- Naive Bayes Learner< 1 %
- PNN Learner (DDA)< 1 %
- Cluster Assigner< 1 %
- Hierarchical Clustering< 1 %
- k-Means< 1 %
- Decision Tree Learner< 1 %
- MultiLayerPerceptron Predictor< 1 %
- RProp MLP Learner< 1 %
Logistic Regression Learner< 1 %- Polynomial Regression Learner< 1 %
- SMOTE< 1 %
- PCA Compute< 1 %
- Random Forest Learner< 1 %
- Random Forest Predictor (Regression)< 1 %
- Simple Regression Tree Learner< 1 %
- Simple Regression Tree Predictor< 1 %
Concatenate (Optional in)< 1 %- Auto-Binner< 1 %
- Case Converter< 1 %
Cell Replacer< 1 %- Column Renamer (Dictionary)< 1 %
- Many to One< 1 %
Linear Correlation< 1 %- Linear Correlation< 1 %
- Duplicate Row Filter< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- Filter Apply Row Splitter< 1 %
- Row Filter (Labs)< 1 %
Joiner< 1 %- Normalizer (Apply)< 1 %
- Denormalizer< 1 %
Normalizer< 1 %- Missing Value (Apply)< 1 %
- Normalizer (PMML)< 1 %
- Rank< 1 %
- Reference Column Resorter< 1 %
- Row Sampling< 1 %
- String Manipulation (Multi Column)< 1 %
- String Replacer< 1 %
- Renderer to Image< 1 %
Rank Correlation< 1 %- Numeric Outliers< 1 %
CASE Switch Data (End)< 1 %- Extract Table Dimension< 1 %
- Conditional Box Plot (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- SDF Stripper< 1 %
- DB Insert< 1 %
- TimeDelay Loop End< 1 %
- Time Series Generator< 1 %
- Numeric Distances< 1 %
- Distance Matrix Calculate< 1 %
- Keras Network Learner< 1 %
- Bar Chart (JavaScript)< 1 %
- Box Plot (JavaScript)< 1 %
- Contour Plot (Plotly)< 1 %
- Histogram (JavaScript)< 1 %
- Parallel Coordinates Plot (JavaScript)< 1 %
- Stacked Area Chart (JavaScript)< 1 %
- Sunburst Chart (JavaScript)< 1 %
- Bar Chart (JFreeChart)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- HeatMap (JFreeChart)< 1 %
- Histogram Chart (JFreeChart)< 1 %
- OSM Map View< 1 %
XLS Sheet Appender< 1 %Excel Writer (XLS)< 1 %- Radar Plot Appender< 1 %
- Google Sheets Writer< 1 %
- Value Selection Configuration< 1 %
- Column Selection (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Tile View (JavaScript)< 1 %
- Column Filter Widget< 1 %
- Table to JSON< 1 %
- Average Filter< 1 %
- Image Viewer< 1 %
- Parameter Optimization Loop End< 1 %
Python Script (1⇒1)< 1 %- Python Learner (legacy)< 1 %
- Table Difference Checker< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Modify Time< 1 %
- Time Field Extractor (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Byte Converter< 1 %
- Workflow Service Input< 1 %
- XGBoost Predictor (Regression)< 1 %
Views
- This node has no views
Workflows
01_Data_PreparationKNIME Hub- 01_Data_PreparationKNIME Hub
- 01_Example_of_Time_Series_FunctionalityKNIME Hub
- 01_Example_of_Time_Series_FunctionalityKNIME Hub
- 01_Guided_VisualizationKNIME Hub
- Show all 144 workflows
Links
- Need help (very new to this field)by ipazin on 2019-03-11forum.knime.com/p/55946
- Choice for time series loopingby HansS on 2019-11-21forum.knime.com/p/75296
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.