Need Help Chart for Order Approval and Creation by Time Range

[vynguyen]

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?

[Irwan · Accepted solution]

hello @vynguyen 

is this what you are looking for?

if yes, then you just need to unpivot your data

Hope this will help.

Thank you.