Filtering values based on day and period to get the average based on total count of record

[kv-defy]

I have a table on different days (Monday to Friday) at different dates and Period (1 to 24). 

Day	Period	Count
Monday	1	5
...	...	...
Monday	24	24
Tuesday	1	6
...	...	...
Tuesday	24	17

I want to sum the total count based on the filtered value (e.g. Day = Monday, Period = 1) and divide the number of record counts. If there are 5 record count with Monday and Period 1, the total sum of the count will divide by 5 (which is the record count). Tentatively my workflow is to filter one by one based on the day first then divide by the period. Is there any faster way to do this? Please advise. Thank you. 

Update: Included input file

[grazitti_sapna]

@kv-defy , Can you please elaborate more on how you want the output or provide us with the input and output files of the data, because I am confused here on whether you want this on 1 particular filter of day Monday and Period 1 or for all combinations of day and period present in table.

[kv-defy]

@grazitti_sapna I have included the input file.

For each period (e.g. 00:00 AM to 00:30 AM) of the same day, I want to sum the total count and count the number of records. The total count will divide by the count of records. I want to do it for all the days (Monday to Sunday) and all the periods (48 different periods because it is in 30 minutes interval) 

[binuacs]

@kv-defy are you looking for something below

[grazitti_sapna]

@kv-defy ,here is my solution. the output is similar to @binuacs just a little different workflow. I hope this works!!