I have been trying to create a query that shows only days when patrols were conducted, but I am struggling to filter out non-patrolled days. I checked the “exclude days with no data” option in the number of patrol hours value to no avail, and I can’t seem to find any other function that would achieve this. Any and all help is greatly appreciated!
Thanks in advance,
Sarah.
Assuming you are putting this into a report, you can do this through a filter in the table when you add it to the report. In this case, the filter could be for either value (distance or number of patrols). Just make your filter, for example, “Distance > 0” in the table and it will exclude any rows where that parameter isn’t met.
1 Like