Forum Discussion
Solved
Need Help Chart for Order Approval and Creation by Time Range
| RangeCreateDate | RangeReceiptDate | id |
| Chiều (14:00 - 18:00) | Đêm (22:00 - 06:00) | 77815 |
| Chiều (14:00 - 18:00) | Đêm (22:00 - 06:00) | 78431 |
| Chiều (14:00 - 18:00) | Đêm (22:00 - 06:00) | 79829 |
| Chiều (14:00 - 18:00) | Đêm (22:00 - 06:00) | 80177 |
| Chiều (14:00 - 18:00) | Đêm (22:00 - 06:00) | 80281 |
| Chiều (14:00 - 18:00) | Sáng (06:00 - 12:00) | 77808 |
| Chiều (14:00 - 18:00) | Sáng (06:00 - 12:00) | 77812 |
| Chiều (14:00 - 18:00) | Sáng (06:00 - 12:00) | 77851 |
| Chiều (14:00 - 18:00) | Sáng (06:00 - 12:00) | 77913 |
I want to create a chart with two columns for each time range. Column 1: the number of orders approved during that time range corresponding to RangeCreateDate. Column 2: the number of orders created during that time range corresponding to RangeReceiptDate. Could someone please help me with this?
