Icon

20221208_​share_​weekly_​totals_​by_​month_​v01

20221208_share_weekly_totals_by_month_v1

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

myDateReporting Month ReferenceInput TableExtract:Year, Month, WeekExtract:Year, Month, Weekand Day of the WeekPossible Use CaseShared Weekly Quantity in Months RIGHT OUTER JOIN criteria: Week Number + YearYear, Month, WeekSum(value)Exclude Saturday|SundayAdd constant value = 1week days percentowning to monthSum Weekly QuantityReference Table Weekly Month Percentages Shared Total Weekly Quantity by MonthTable Creator Create Date&TimeRange Extract Date&TimeFields Extract Date&TimeFields Joiner GroupBy Row Filter ConstantValue Column Math Formula GroupBy Sorter Math Formula myDateReporting Month ReferenceInput TableExtract:Year, Month, WeekExtract:Year, Month, Weekand Day of the WeekPossible Use CaseShared Weekly Quantity in Months RIGHT OUTER JOIN criteria: Week Number + YearYear, Month, WeekSum(value)Exclude Saturday|SundayAdd constant value = 1week days percentowning to monthSum Weekly QuantityReference Table Weekly Month Percentages Shared Total Weekly Quantity by MonthTable Creator Create Date&TimeRange Extract Date&TimeFields Extract Date&TimeFields Joiner GroupBy Row Filter ConstantValue Column Math Formula GroupBy Sorter Math Formula

Nodes

Extensions

Links