Finding out Delivery Times

[agreekgod]

My aim is to create a bar chart denoting the frequency of delivery times, to see whether most orders take one or two or three days etc to be delivered. I have the delivery times for all the orders. How do I find the quantity of orders which satisfy each delivery time using the Query Builder? Thanks

[TomKari · Accepted solution]

1. If your delivery time is not a number of seconds, I suggest you convert it to that, as it will be easiest to work with.

2. Create a format for your durations, something along the lines of:

'00:00:00't - '23:59:59't = 'less than 1 day'

'24:00:00't - '47:59:59't = '1 to 2 days'

3. Apply your format, and when you run your bar chart it should group the observations by the format labels.

Tom