We here demonstrate how a date/time column can be filtered to contain only the last k month or week or days. On the webportal you chose the granularity and the number of those granularity you want to include in your analysis. Afterwards we filter them using the time difference (set to the selected granularity) and the rowfilter on the time difference value limited by the selected number of.
One example would be that we want to include the last 4 weeks of data since today. Than we would set the granularity to Week and the Number to four. The last page in the webportal show the minimum and maximum date after the filtering.
EXAMPLES Server: 09_Enterprise/02_WebPortal/05_Select_most_recent_date_and_time_cells09_Enterprise/02_WebPortal/05_Select_most_recent_date_and_time_cells*
Download a zip-archive
* Find more about the Examples Server here.
The link will open the workflow directly in KNIME Analytics Platform (requirements: Windows; KNIME Analytics Platform must be installed with the Installer version 3.2.0 or higher). In other cases, please use the link to a zip-archive or open the provided path manually