Newbie here. I have a column named category which contains 5 variables (M1 - M2- M3 - M4- M5). For each variable, the amount is collected since 2018 on a monthly basis. What I am trying to do is to present each variable at a time in a line chart on a monthly basis: so what I want to showfor example, is 3 lines of M1 (M1 2018 - M1 2019 - M1 2020) with y amount in USD and x is the months (1 to 12). Help please? 🙂
| d_categ | Year | Month | Avg_amount |
| M1 | 2019 | 1 | 2241 |
| M1 | 2019 | 2 | 2401 |
| M1 | 2019 | 3 | 2731 |
| M1 | 2019 | 4 | 2722 |
| M1 | 2019 | 5 | 2383 |
| M1 | 2019 | 6 | 2283 |
| M1 | 2019 | 7 | 2335 |
| M1 | 2019 | 8 | 2552 |
| M1 | 2019 | 9 | 2423 |
| M1 | 2019 | 10 | 2362 |
| M1 | 2019 | 11 | 350 |
| M1 | 2019 | 12 | 3957 |
| M1 | 2020 | 1 | 2239 |
| M1 | 2020 | 2 | 2658 |
| M1 | 2020 | 3 | 2681 |
| M1 | 2020 | 4 | 3278 |
| M1 | 2020 | 5 | 2932 |
| M1 | 2020 | 6 | 2484 |
| M2 | 2020 | 1 | 3493 |
| M2 | 2020 | 2 | 1211 |
| M2 | 2020 | 3 | 3940 |
| M2 | 2020 | 4 | 0 |
| M2 | 2020 | 5 | 0 |
| M2 | 2019 | 1 | 877 |
| M2 | 2019 | 2 | 359 |
| M2 | 2019 | 3 | 8264 |
| M2 | 2019 | 4 | 1034 |
| M2 | 2019 | 5 | 3938 |
| M2 | 2019 | 6 | 9630 |
| M2 | 2019 | 7 | 0 |
| M2 | 2019 | 8 | 4012 |
| M2 | 2019 | 9 | 8832 |
| M2 | 2019 | 10 | 1231 |
| M2 | 2019 | 11 | 1616 |
| M2 | 2019 | 12 | 1275 |
| M2 | 2020 | 1 | 6400 |
| M2 | 2020 | 2 | 3405 |
| M2 | 2020 | 3 | 8843 |
| M2 | 2020 | 4 | 1154 |
| M2 | 2020 | 5 | 1200 |
| M2 | 2020 | 6 | 5006 |
| M3 | 2019 | 1 | 3188 |
| M3 | 2019 | 2 | 3916 |
| M3 | 2019 | 3 | 5869 |
| M3 | 2019 | 4 | 2596 |
| M3 | 2019 | 5 | 2234 |
| M3 | 2019 | 6 | 7875 |
| M3 | 2019 | 7 | 2472 |
| M3 | 2019 | 8 | 7537 |
| M3 | 2019 | 9 | 2941 |
| M3 | 2019 | 10 | 3577 |
| M3 | 2019 | 11 | 4250 |
| M3 | 2019 | 12 | 8869 |
| M3 | 2020 | 1 | 4210 |
| M3 | 2020 | 2 | 9248 |
| M3 | 2020 | 3 | 3418 |
| M3 | 2020 | 4 | 7651 |
| M3 | 2020 | 5 | 2069 |
| M3 | 2020 | 6 | 3319 |
