As the subject mentions I have weekly sales data for last 3 years, that are split on multiple categories like country, Segments, Devices, entitlement status and marketing channel. I do not have daily data. So, my date metrics are fiscal_year (yyyy), qtr(Q#) and Week(ww) all are in text format and weeks are of 01, 02 and not 1,2.
My need is to create a column to get previous year's data in a new column.
I have 21 segments and 3 years worth data.. fw is week
can you share some sample data?
Desktop | 2020 | 1 | Segment1 | Organic | ANZ | Q1 | 781 |
Desktop | 2020 | 1 | Segment1 | Organic | CHN | Q1 | 3 |
Desktop | 2020 | 1 | Segment1 | Organic | HKT | Q1 | 330 |
Desktop | 2020 | 1 | Segment1 | Organic | IN | Q1 | 387 |
Desktop | 2020 | 1 | Segment1 | Organic | KOR | Q1 | 319 |
Desktop | 2020 | 1 | Segment1 | Organic | SEA | Q1 | 285 |
Desktop | 2020 | 1 | Segment1 | Paid Media | ANZ | Q1 | 683 |
Desktop | 2020 | 1 | Segment1 | Paid Media | CHN | Q1 | 2 |
Desktop | 2020 | 1 | Segment1 | Paid Media | HKT | Q1 | 133 |
Desktop | 2020 | 1 | Segment1 | Paid Media | IN | Q1 | 148 |
Desktop | 2020 | 1 | Segment1 | Paid Media | KOR | Q1 | 238 |
Desktop | 2020 | 1 | Segment1 | Paid Media | SEA | Q1 | 138 |
Desktop | 2020 | 1 | Segment1 | Product | ANZ | Q1 | 2162 |
Desktop | 2020 | 1 | Segment1 | Product | CHN | Q1 | 15 |
Desktop | 2020 | 1 | Segment1 | Product | HKT | Q1 | 479 |
Desktop | 2020 | 1 | Segment1 | Product | IN | Q1 | 339 |
Desktop | 2020 | 1 | Segment1 | Product | KOR | Q1 | 935 |
Desktop | 2020 | 1 | Segment1 | Product | SEA | Q1 | 342 |
Desktop | 2020 | 1 | Segment1 | Unknown | ANZ | Q1 | 19 |
Desktop | 2020 | 1 | Segment1 | Unknown | CHN | Q1 | 0 |
Desktop | 2020 | 1 | Segment1 | Unknown | HKT | Q1 | 8 |
Desktop | 2020 | 1 | Segment1 | Unknown | IN | Q1 | 14 |
Desktop | 2020 | 1 | Segment1 | Unknown | KOR | Q1 | 12 |
Desktop | 2020 | 1 | Segment1 | Unknown | SEA | Q1 | 7 |
Desktop | 2020 | 1 | Segment2 | Organic | ANZ | Q1 | 2888 |
Desktop | 2020 | 1 | Segment2 | Organic | CHN | Q1 | 239 |
Desktop | 2020 | 1 | Segment2 | Organic | HKT | Q1 | 985 |
User | Count |
---|---|
78 | |
43 | |
36 | |
14 | |
13 |
User | Count |
---|---|
86 | |
31 | |
27 | |
18 | |
13 |