Hello,
I have following mySQL table
| date | order_number | channel |
|---|---|---|
| 2019-04-30 | 123123123 | online |
| 2019-05-20 | 84835834 | offline |
| 2019-05-20 | 9884545 | offline |
I want to generate column chart which will count number of orders in each channel group by month, the data will be something like this.
| month | online | offline |
|---|---|---|
| 2019-04 | 1 | 0 |
| 2019-05 | 0 | 2 |