Thank you, that’s helpful.
My understanding is you have 14 people who check classrooms throughout the week, and that each person completes up to two forms per classroom. All reports are stored in a single table. The supervisor would like a view that shows all reports completed by a given person for a given week.
Based on my understanding, this is what I imagine you need (change names to suit your preference):
-
A table containing completed reports, named Reports.
-
Each reports table has at least the following columns:
-
Classroom that identifies the classroom.
-
Who Checked that identifies the person who performed the check.
-
When Checked that identifies when the check was performed, as a DateTime value.
-
The supervisor has user settings of those same column names that allows them to choose their desired filter values.
-
A slice named Supervisor Filter that uses the following row filter expression to include only the desired rows from Reports according to the supervisor’s user settings:
AND(
(USERSETTINGS("Classroom") = [Classroom]),
(USERSETTINGS("Who Checked") = [Who Checked]),
((USERSETTINGS("When Checked") - DAY(USERSETTINGS("When Checked"))) = ([When Checked] - DAY([When Checked])))
)
-
A view named Classroom Reports that uses the Supervisor Filter as its data set to display the results of the supervisor’s filter for Reports.
LinkedIn
Twitter
