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

Question

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

DayPeriodCountMonday15.........Monday2424Tuesday16.........Tuesday2417

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

kv-test.xlsx

grazitti_sapna · Answer

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

Period_Day_wf.yxmd

binu_acs · Answer

@kv-defy are you looking for something below

Filter_0905.yxmd

kv-defy · Answer

@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)