SergioSanchez1
6 years agoQrew Trainee
Group and filter by "customized week"
#Formulaandfunctions #reportsandcharts #Formulasandfunctions
Hello
I would like to get assistance on how to group and filter records based on particular criteria: workweek from Wednesday to Tuesday. For example, on excel I can do it like this:
so as you can see, I can count records if the date is between the range established in excel - from Wed to Tue. Basically the need is to group and count records based on customized date ranges. Each record has it own "Sent to 1st level Review date", I just need the count based on those ranges and then show them in Summary or Table reports.
I hope it was clear enough. Thanks in advanced.
Regards,
------------------------------
Sergio Sanchez
------------------------------
Hello
I would like to get assistance on how to group and filter records based on particular criteria: workweek from Wednesday to Tuesday. For example, on excel I can do it like this:
so as you can see, I can count records if the date is between the range established in excel - from Wed to Tue. Basically the need is to group and count records based on customized date ranges. Each record has it own "Sent to 1st level Review date", I just need the count based on those ranges and then show them in Summary or Table reports.
I hope it was clear enough. Thanks in advanced.
Regards,
------------------------------
Sergio Sanchez
------------------------------