Tracking Inspections over Time

[The_Game]

Hello you amazing people!

I want to build a flexible time range query wherein the query refers to a table of inspections that happen throughout the year. For example, I want to see the number of inspections that happened from 4 July 2020 - 6 April 2021 or 19 Oct 20 - 30 Sept 21, etc. The type of inspections we have vary from 7d, 14d, 30d, 60d, 90d, 180d, and 360 day. The inspection dates can vary, but for the purpose of this product they'll remain fixed. How can I go about doing this?

Thank you so much!

~Mike

 

[GlennUK]

Show an example of the table.

 

[The_Game]

image failed to load, so see below. thank you!

 

[The_Game]

	jan	feb	mar	apr	may	jun	july	aug	sep
7	5	4	4	4	5	4	5	4
14	2	2	2	2	3	2	3	2	2
30	1	1	1	1	1	1	1	1	1
60	0	1	0	1	0	1	0	1	0
90	0	0	1	0	0	1	0	0	1
180	1	0	0	0	0	0	1	0	0
360	1	0	0	0	0	0	0	0	0

 

[The_Game]

Google Chrome for the win! See the top portion for reference

 

[GlennUK]

Explain the tables - and explain where the date range is there, as I can't see it.