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.
Created with KNIME Analytics Platform version (unknown version)