Desktop productivity for business analysts and programmers

Finding out Delivery Times

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 19
Accepted Solution

Finding out Delivery Times

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


Accepted Solutions
Solution
‎04-15-2015 10:22 AM
Trusted Advisor
Posts: 1,051

Re: Finding out Delivery Times

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

View solution in original post


All Replies
Solution
‎04-15-2015 10:22 AM
Trusted Advisor
Posts: 1,051

Re: Finding out Delivery Times

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 231 views
  • 1 like
  • 2 in conversation