Icon

Group_​week

There has been no title set for this workflow's metadata.

There has been no description set for this workflow's metadata.

Extracts all weeks Extract current week addweeknumberrenameWWremoveweeknumberaddtotalscolumnvariablecreatesWWgroup weekpivoot dateagregate valuesum/totalgroupon weekNode 52Date& valuevariablecreatesWWaddweeknumbergroup weekpivoot dateagregate valuesum/totalrenameWWremoveweeknumbergroupon weekweekNode 62Node 63addtotalscolumnfilterweeknumbertodayweeknumbervariablecreatesWWweek Extract Date&TimeFields Column Renamer Column Filter Column Appender Table RowTo Variable VariableExpressions Pivot Group Loop Start Loop End (ColumnAppend) Table Creator Table RowTo Variable VariableExpressions Extract Date&TimeFields Pivot Column Renamer Column Filter Group Loop Start GroupBy Loop End (ColumnAppend) Table Creator Column Appender Row Filter Create Date&TimeRange Extract Date&TimeFields Table RowTo Variable VariableExpressions GroupBy Extracts all weeks Extract current week addweeknumberrenameWWremoveweeknumberaddtotalscolumnvariablecreatesWWgroup weekpivoot dateagregate valuesum/totalgroupon weekNode 52Date& valuevariablecreatesWWaddweeknumbergroup weekpivoot dateagregate valuesum/totalrenameWWremoveweeknumbergroupon weekweekNode 62Node 63addtotalscolumnfilterweeknumbertodayweeknumbervariablecreatesWWweek Extract Date&TimeFields Column Renamer Column Filter Column Appender Table RowTo Variable VariableExpressions Pivot Group Loop Start Loop End (ColumnAppend) Table Creator Table RowTo Variable VariableExpressions Extract Date&TimeFields Pivot Column Renamer Column Filter Group Loop Start GroupBy Loop End (ColumnAppend) Table Creator Column Appender Row Filter Create Date&TimeRange Extract Date&TimeFields Table RowTo Variable VariableExpressions GroupBy

Nodes

Extensions

Links