Help creating a report that can select date ranges of information.

Coen

Good afternoon everyone!

I am working on a traffic counter for a few separate locations. The counter is collecting very basic information:

Location, AM visits, PM visit and a Yes/No question.

once the form collects the data an automation then moves the input data to one of the four locations own sheet. (MA,TX, China, Japan)

These individual sheets then feed into a report that will display the collected information.

What I am trying to do is set up the report so we can view specific date ranges.

Example: I want to see how many visits MA had between M - F of a given week or a date range that covers a specific month.

Thank you for any help!

-Rob

Mike TV

@Coen

When setting up your filters in the report, select your Date Column and then select the condition "is between" it will give you two date boxes to fill in for your start and end dates the filter is supposed to search between.

Mike TV

@Coen

Will this work for you? When you're setting up filters within your report, you can choose a column with a date and specify your date range like so:

Coen

Hi Mike!

Sorry I am unable to see the image :(

Mike TV

@Coen

When setting up your filters in the report, select your Date Column and then select the condition "is between" it will give you two date boxes to fill in for your start and end dates the filter is supposed to search between.

Coen

gotcha, I will try that and see if it works for what we are trying to accomplish.

tyty!!

Coen

Thank you, I have successfully set up the filter.

Mike TV

@Coen

Glad that worked for you. The only possible hangup is that I'm not sure if unlicensed users will be able to modify the filter search range. You'll have to test it out and see. You probably will have to give them editor access as well to be able to change those values, if they can.