Forum Discussion
Solved
Display data with different time duration together
I have to show weekly data in two years together, in which the data in previous year has 52 weeks, and the data in current year has YTD. I would like to know how to show them together like the pictur...
Okay, Thank you.
Hi Lydia, thank you for your response. Below is my dummy data. I want to show the both 2017 and 2018 year's percentage together.
| YEAR | WEEK | % |
| 2017 | 2 | 81% |
| 2017 | 3 | 91% |
| 2017 | 4 | 54% |
| 2017 | 5 | 48% |
| 2017 | 6 | 67% |
| 2017 | 9 | 81% |
| 2017 | 11 | 25% |
| 2017 | 13 | 61% |
| 2017 | 15 | 80% |
| 2017 | 16 | 45% |
| 2017 | 17 | 77% |
| 2017 | 18 | 72% |
| 2017 | 19 | 52% |
| 2017 | 21 | 100% |
| 2017 | 22 | 48% |
| 2017 | 23 | 75% |
| 2017 | 24 | 20% |
| 2017 | 25 | 49% |
| 2017 | 26 | 77% |
| 2017 | 27 | 73% |
| 2017 | 28 | 29% |
| 2017 | 29 | 58% |
| 2017 | 30 | 78% |
| 2017 | 31 | 56% |
| 2017 | 32 | 48% |
| 2017 | 33 | 71% |
| 2017 | 34 | 83% |
| 2017 | 35 | 94% |
| 2017 | 36 | 57% |
| 2017 | 37 | 60% |
| 2017 | 38 | 61% |
| 2017 | 39 | 90% |
| 2017 | 40 | 58% |
| 2017 | 41 | 72% |
| 2017 | 42 | 69% |
| 2017 | 43 | 61% |
| 2017 | 44 | 55% |
| 2017 | 45 | 47% |
| 2017 | 46 | 54% |
| 2017 | 47 | 51% |
| 2017 | 48 | 48% |
| 2017 | 49 | 48% |
| 2017 | 50 | 72% |
| 2017 | 51 | 54% |
| 2017 | 52 | 37% |
| 2018 | 1 | 44% |
| 2018 | 2 | 61% |
| 2018 | 3 | 52% |
| 2018 | 4 | 61% |
| 2018 | 5 | 42% |
| 2018 | 6 | 51% |
| 2018 | 7 | 33% |
| 2018 | 8 | 10% |
| 2018 | 10 | 50% |
| 2018 | 11 | 41% |
| 2018 | 12 | 45% |
| 2018 | 13 | 84% |