topic Re: Finding out Delivery Times in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Finding-out-Delivery-Times/m-p/196333#M14889 <HTML><HEAD></HEAD><BODY><P>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.</P><P>2. Create a format for your durations, something along the lines of:</P><P>'00:00:00't - '23:59:59't = 'less than 1 day'</P><P>'24:00:00't - '47:59:59't = '1 to 2 days'</P><P>3. Apply your format, and when you run your bar chart it should group the observations by the format labels.</P><P></P><P>Tom</P></BODY></HTML> Wed, 15 Apr 2015 14:22:26 GMT TomKari 2015-04-15T14:22:26Z Finding out Delivery Times https://communities.sas.com/t5/SAS-Enterprise-Guide/Finding-out-Delivery-Times/m-p/196332#M14888 <HTML><HEAD></HEAD><BODY><P>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 </P></BODY></HTML> Wed, 15 Apr 2015 11:45:27 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Finding-out-Delivery-Times/m-p/196332#M14888 agreekgod 2015-04-15T11:45:27Z Re: Finding out Delivery Times https://communities.sas.com/t5/SAS-Enterprise-Guide/Finding-out-Delivery-Times/m-p/196333#M14889 <HTML><HEAD></HEAD><BODY><P>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.</P><P>2. Create a format for your durations, something along the lines of:</P><P>'00:00:00't - '23:59:59't = 'less than 1 day'</P><P>'24:00:00't - '47:59:59't = '1 to 2 days'</P><P>3. Apply your format, and when you run your bar chart it should group the observations by the format labels.</P><P></P><P>Tom</P></BODY></HTML> Wed, 15 Apr 2015 14:22:26 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Finding-out-Delivery-Times/m-p/196333#M14889 TomKari 2015-04-15T14:22:26Z