Icon

2. Advanced Date & Time Manipulation

<p><strong>Advanced Date &amp; Time Manipulation</strong></p><p>This workflow shows more advanced Date &amp; Time manipulation nodes and additionally visualizes the results. The tasks include:</p><ul><li><p>extracting data rows falling in a time window (<em>Date&amp;Time-based Row Filter</em>),</p></li><li><p>extracting fields (day, year, hour, etc.) from Date&amp;Time columns (<em>Date&amp;Time Part Extractor</em>),</p></li><li><p>calculating a time difference to another Date&amp;Time value (<em>Date&amp;Time Difference</em>), and</p></li><li><p>calculating moving average and moving aggregation (<em>Moving Average</em> and <em>Moving Aggregator</em>).</p></li></ul><p>The results are visualized in various line plots.</p>

Moving Average and Moving Aggregation

Date&Time operations

Workflow: Advanced Date &Time Manipulation


This workflow shows more advanced Date & Time manipulation nodes and additionally visualizes the results. The tasks include:

  • extracting data rows falling in a time window (Date&Time-based Row Filter),

  • extracting fields (day, year, hour, etc.) from Date&Time columns (Date&Time Part Extractor),

  • calculating a time difference to another Date&Time value (Date&Time Difference), and

  • calculating moving average and moving aggregation (Moving Average and Moving Aggregator).

The results are visualized in various line plots.

Reading data

Center simple moving average of quantity (window length = 11)
Moving Average
Keep rows wherenumber of months >12
Row Filter
Filter rows: year=2010
Row Filter
Filter rows:01.01.2009 - 01.01.2010
Date&Time-based Row Filter
Time difference (in days)to previous row
Date&Time Difference
Sort date columnin ascending order
Sorter
Convert sale dateinto Date&Time object
String to Date&Time
Number ofmonths to today
Date&Time Difference
sales.csv
CSV Reader
Visualize differenceover the months
Line Plot
Visualize cumulative sumby date
Line Plot
Extract year, month,day, and day of week
Date&Time Part Extractor
Cumulative sumof amount
Moving Aggregator
Visualize moving averageby date
Line Plot
Count rowsby weekday
GroupBy

Nodes

Extensions

Links