Adding queries for total audits, validations, and average per 100 m t…

JeremyFreiburger commented 3 weeks ago

…o admin dashboard

Resolves #2903

I added queries for Total Auditing time, Total validating time, and Average auditing time per 100 meters for users with over 30 minutes of auditing and at-least 100 meters. I created 3 queries for each of these for total, last 24 hours, and past week. The total audits and validations are in hours and the average auditing is in minutes.

Before/After screenshots (if applicable)

Testing instructions

Things to check before submitting the PR

[x] I've written a descriptive PR title.
[x] I've added/updated comments for large or confusing blocks of code.
[ ] I've included before/after screenshots above.
[ ] I've asked for and included translations for any user facing text that was added or modified.
[ ] I've updated any logging. Clicks, keyboard presses, and other user interactions should be logged. If you're not sure how (or if you need to update the logging), ask Mikey. Then make sure the documentation on this wiki page is up to date for the logs you added/updated.
[ ] I've tested on mobile (only needed for validation page).

jonfroehlich commented 2 weeks ago

Would love screenshots of this too. Thanks!

JeremyFreiburger commented 2 weeks ago

ProjectSidewalk / SidewalkWebpage