Icon

Time Tracking Minimal - edited knime forum

inputto Tracking_DaystartDateduration in secondsstart end timefilter enddatedurationcounts onlysplit tagspivot durationungroup per tagcreate a collectionpivot countsappend sum and countcolumn suffixcolumn suffixdurationgroupby day, activity, tagduration / number of # in collectionresortactivity and dayCSV Reader Column Rename String to Date&Time Date&TimeDifference String to Date&Time Column Filter Column Filter Cell Splitter Pivoting Ungroup Create CollectionColumn Pivoting Column Appender Column Rename(Regex) Column Rename(Regex) Column Expressions GroupBy Column Expressions Column Re-sorterflow variable Column Resorter Column Rename inputto Tracking_DaystartDateduration in secondsstart end timefilter enddatedurationcounts onlysplit tagspivot durationungroup per tagcreate a collectionpivot countsappend sum and countcolumn suffixcolumn suffixdurationgroupby day, activity, tagduration / number of # in collectionresortactivity and dayCSV Reader Column Rename String to Date&Time Date&TimeDifference String to Date&Time Column Filter Column Filter Cell Splitter Pivoting Ungroup Create CollectionColumn Pivoting Column Appender Column Rename(Regex) Column Rename(Regex) Column Expressions GroupBy Column Expressions Column Re-sorterflow variable Column Resorter Column Rename

Nodes

Extensions

Links