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.
Used extensions & nodes
Created with KNIME Analytics Platform version 4.1.0
Loading ad hoc jobs
By using or downloading the workflow, you agree to our terms and conditions.