Forum Discussion
Helper VAverage Clients Per Hour, over a monthly timeframe
Super UserMy business is a call centre, we 'see / talk to' clients on a 24 / 7 basis, even bank holidays, Xmas etc. It's a round the clock business.
Is it , or is it not?
Helper Vlbendlin It is - don't forget, this is sample data, so it is not going to be 100% correct to my business model I'm using. As I said, there WILL be blank days at the beginning when we were starting up.
Just wanting to find a way to calculate this - if you can help, great. It looks like this has stumped most of the community.
- lbendlin
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided. - Creative_tree88
- Creative_tree88
lbendlin To do that would mean providing 10 years worth of data!? Surely my issue was self explanatory - I need average numbers of clients seen, per hour - but averaged out on a monthly basis. Some days will have blanks (certainly around 2014/15) as per my sample data, but the principle should be consistent i.e. only count those days with data, to form accurate average, regardless of whether that date has a full set of numbers or partial. This IS representative of the data.
My expected outcome has been detailed earlier in the original message...??
- foodd
Community Champion
Creative_tree88 , lbendlin's reply is of good nature and tempered with much value and experience. Would you please consider trimming a resonable sample data set that fully covers your issue, and support that with expected outcome based on the sample data provided. If a yearly view is of interest, slice off a rolling year worth as your bucket.
