Forum Discussion
Help with Classroom Availability filter
I am tring to return a list of available classrooms based on a period selection in slicer. Basically I have columns for Room and period. When a period is selected in the slicer it should return all classrooms that have NO classes scheduled for that period. I tried making some inverse slicers, but have had no luck. Data table is below. Any help would be appreciated.
2 Replies
Hi fil1951 ，
Is there a table of the classroom schedule for each time period? The table you have provided so far, I can't tell from it when it is inactive.
Best Regards
Lucien
Well that would be easy if we recorded periods where the room is not used. Unfortunately, we only record periods that the room is in use in teacher/student schedules, so I need to extrapolate the free periods from the periods it is in use. From a 7 period day with 3 lunch periods (4abc and 5abc), I can see from the table that room 102 is available during period 3, 4b, 4c, 5b, 5c and 7.
