Average Clients Per Hour, over a monthly timeframe

foodd and lbendlin  I'll sort some data etc out for you. Thanks for your persistence.

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...??

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.