Thanks for that man 🙂

Much appreciated and thanks for the quick responses.

Cheers,

Byron

Query resolved. Will be a while before I post again as I obviously need to learn more before I ask for assistance. Dont even understand what I need to do...

Wayne you 100% correct. Fortunately, I am using just data and not actually implementing anything in the real world. All the databases I have are stored on my desktop and...

Derek you are the man 😀

I couldn't quite understand exactly what you did 🙂 but took some stuff you used and added it to my query. The result ..... exactly...

Sorry Tom,

I have to be off now. I will be on later tonight and will post properly as per best practises. Thanks for taking the time and being patient with...

Thanks Tom,

Was just reading the best practises and saw that what I did is the first thing they discourage uses from doing LOL

OK lets try that again here we go

DateInterval_Start_TimeACD_CallsAban_CallsPercentage...

My bad,

Hit the enter button before I finished typing. Below is a table I did in excel with what I am looking for

DateInterval_Start_TimeACD_CallsAban_CallsPercentage Distribution

01-May07:30000.0%

01-May08:00803.6%

01-May08:301105.0%

01-May09:001808.1%

01-May09:30904.1%

01-May10:002109.5%

01-May10:3025011.3%

01-May11:001908.6%

01-May11:301808.1%

01-May12:001808.1%

01-May12:3032014.5%

01-May13:0030013.6%

01-May13:301004.5%

01-May14:00200.9%

02-May07:30000.0%

02-May08:001207.4%

02-May08:30704.3%

02-May09:001308.0%

02-May09:301006.1%

02-May10:001609.8%

02-May10:301207.4%

02-May11:001207.4%

02-May11:301308.0%

02-May12:0019011.7%

02-May12:3024014.7%

02-May13:00603.7%

02-May13:301408.6%

02-May14:00503.1%

03-May07:30000.0%

03-May08:00213.4%

03-May08:3010011.2%

03-May09:00606.7%

03-May09:30606.7%

(Sorry about the shit display, haven't figured...

Hi Tom,

Thanks very much for your reply. Unfortunately 🙂 the result is not what I am looking for. Firstly, I'll go check out the link you provided (maybe it will...