i have a data set that shows the exams for the full mock exam period, i have it set to show the current exam but have been thinking that maybe showing the next exam would be better.
is there a filter that i can use that will show the data for today by the next on on the list based on the time.
exam1 today 09:00
exam2 today 10:00
exam3 today 11:00
exam4 today 14:00
say the time is 10:10.
I don't want to show exam 2 as it is happening and that's no use to the students doing the exam, I want to show exam 3 so students can do revision on the subject, but i don't want to show exam 4 as that can cause confusion
i know its hard to follow, apologies for that