How to group duplicate dates?

Hi

i wanted to group these duplicate dates into one field, the way i want this to happen is, if i group a specific date then all the corresponding fields must also be either summed or averaged.

every date has 24 rows for 24 hours that needs to be grouped in 1 date and other column, example count of bike shares must be summed within a single date, similarly other fields should also be averaged or summed.

i was trying to use datesinbetween function for moving average but it won't allow me as there are duplicates in date field.

thanks in advance.