Spreadsheet: 90369d1290102798-aggregate-weekly-data-by-by-another-condition-from-daily-data-dailychannelexample
Sheet: DailyData

 | Date | Channel | Revenue
 | 2010-01-01 00:00:00 | Organic | 12
 | 2010-01-01 00:00:00 | Affiliate | 13
 | 2010-01-01 00:00:00 | [NAME] | 324
 | 2010-01-01 00:00:00 | [NAME] | 534
 | 2010-01-01 00:00:00 | Google Product Search | 5645
 | 2010-01-01 00:00:00 | Vendor Links | 85
 | 2010-01-01 00:00:00 | Shopping Search | 45
 | 2010-01-02 00:00:00 | Organic | 345
 | 2010-01-02 00:00:00 | Affiliate | 52
 | 2010-01-02 00:00:00 | [NAME] | 235
 | 2010-01-02 00:00:00 | [NAME] | 463
 | 2010-01-02 00:00:00 | Google Product Search | 56
 | 2010-01-02 00:00:00 | Vendor Links | 34
 | 2010-01-02 00:00:00 | Shopping Search | 46
 | 2010-01-03 00:00:00 | Organic | 234
 | 2010-01-03 00:00:00 | Affiliate | 675
 | 2010-01-03 00:00:00 | [NAME] | 456
 | 2010-01-03 00:00:00 | [NAME] | 34
 | 2010-01-03 00:00:00 | Google Product Search | 546
 | 2010-01-03 00:00:00 | Vendor Links | 34
 | 2010-01-03 00:00:00 | Shopping Search | 754
 | 2010-01-04 00:00:00 | Organic | 34
 | 2010-01-04 00:00:00 | Affiliate | 6754
 | 2010-01-04 00:00:00 | [NAME] | 457
 | 2010-01-04 00:00:00 | [NAME] | 45
 | 2010-01-04 00:00:00 | Google Product Search | 23
 | 2010-01-04 00:00:00 | Vendor Links | 56
 | 2010-01-04 00:00:00 | Shopping Search | 756
 | 2010-01-05 00:00:00 | Organic | 575
 | 2010-01-05 00:00:00 | Affiliate | 5726
 | 2010-01-05 00:00:00 | [NAME] | 5967
 | 2010-01-05 00:00:00 | [NAME] | 5678
 | 2010-01-05 00:00:00 | Google Product Search | 578
 | 2010-01-05 00:00:00 | Vendor Links | 654
 | 2010-01-05 00:00:00 | Shopping Search | 8976
 | 2010-01-06 00:00:00 | Organic | 65
 | 2010-01-06 00:00:00 | Affiliate | 34
 | 2010-01-06 00:00:00 | [NAME] | 743
 | 2010-01-06 00:00:00 | [NAME] | 457
 | 2010-01-06 00:00:00 | Google Product Search | 4567
 | 2010-01-06 00:00:00 | Vendor Links | 45
 | 2010-01-06 00:00:00 | Shopping Search | 345
 | 2010-01-07 00:00:00 | Organic | 345
 | 2010-01-07 00:00:00 | Affiliate | 45
 | 2010-01-07 00:00:00 | [NAME] | 45
 | 2010-01-07 00:00:00 | [NAME] | 756
 | 2010-01-07 00:00:00 | Google Product Search | 345
 | 2010-01-07 00:00:00 | Vendor Links | 85
 | 2010-01-07 00:00:00 | Shopping Search | 56
 | 2010-01-08 00:00:00 | Organic | 546
 | 2010-01-08 00:00:00 | Affiliate | 54
 | 2010-01-08 00:00:00 | [NAME] | 3456
 | 2010-01-08 00:00:00 | [NAME] | 546
 | 2010-01-08 00:00:00 | Google Product Search | 87
 | 2010-01-08 00:00:00 | Vendor Links | 567
 | 2010-01-08 00:00:00 | Shopping Search | 536
 | 2010-01-09 00:00:00 | Organic | 5467
 | 2010-01-09 00:00:00 | Affiliate | 2
 | 2010-01-09 00:00:00 | [NAME] | 657
 | 2010-01-09 00:00:00 | [NAME] | 42
 | 2010-01-09 00:00:00 | Google Product Search | 13
 | 2010-01-09 00:00:00 | Vendor Links | 643
 | 2010-01-09 00:00:00 | Shopping Search | 324
 | 2010-01-10 00:00:00 | Organic | 345
 | 2010-01-10 00:00:00 | Affiliate | 324
 | 2010-01-10 00:00:00 | [NAME] | 234
 | 2010-01-10 00:00:00 | [NAME] | 2346
 | 2010-01-10 00:00:00 | Google Product Search | 54
 | 2010-01-10 00:00:00 | Vendor Links | 567
 | 2010-01-10 00:00:00 | Shopping Search | 345
 | 2010-01-11 00:00:00 | Organic | 574
 | 2010-01-11 00:00:00 | Affiliate | 567
 | 2010-01-11 00:00:00 | [NAME] | 34
 | 2010-01-11 00:00:00 | [NAME] | 876
 | 2010-01-11 00:00:00 | Google Product Search | 556
 | 2010-01-11 00:00:00 | Vendor Links | 9876
 | 2010-01-11 00:00:00 | Shopping Search | 6785
 | 2010-01-12 00:00:00 | Organic | 34
 | 2010-01-12 00:00:00 | Affiliate | 56
 | 2010-01-12 00:00:00 | [NAME] | 67
 | 2010-01-12 00:00:00 | [NAME] | 34
 | 2010-01-12 00:00:00 | Google Product Search | 43
 | 2010-01-12 00:00:00 | Vendor Links | 345
 | 2010-01-12 00:00:00 | Shopping Search | 34
 | 2010-01-13 00:00:00 | Organic | 3
 | 2010-01-13 00:00:00 | Affiliate | 457
 | 2010-01-13 00:00:00 | [NAME] | 45
 | 2010-01-13 00:00:00 | [NAME] | 345
 | 2010-01-13 00:00:00 | Google Product Search | 34
 | 2010-01-13 00:00:00 | Vendor Links | 456
 | 2010-01-13 00:00:00 | Shopping Search | 34
 | 2010-01-14 00:00:00 | Organic | 43
 | 2010-01-14 00:00:00 | Affiliate | 34
 | 2010-01-14 00:00:00 | [NAME] | 54
 | 2010-01-14 00:00:00 | [NAME] | 76
 | 2010-01-14 00:00:00 | Google Product Search | 245
 | 2010-01-14 00:00:00 | Vendor Links | 754
 | 2010-01-14 00:00:00 | Shopping Search | 345
 | 2010-01-15 00:00:00 | Organic | 425
 | 2010-01-15 00:00:00 | Affiliate | 45
 | 2010-01-15 00:00:00 | [NAME] | 43
 | 2010-01-15 00:00:00 | [NAME] | 45
 | 2010-01-15 00:00:00 | Google Product Search | 435
 | 2010-01-15 00:00:00 | Vendor Links | 45
 | 2010-01-15 00:00:00 | Shopping Search | 54
 | 2010-01-16 00:00:00 | Organic | 4
 | 2010-01-16 00:00:00 | Affiliate | 4576
 | 2010-01-16 00:00:00 | [NAME] | 67
 | 2010-01-16 00:00:00 | [NAME] | 7634
 | 2010-01-16 00:00:00 | Google Product Search | 56
 | 2010-01-16 00:00:00 | Vendor Links | 87
 | 2010-01-16 00:00:00 | Shopping Search | 6564