I'm not going to download the files, but can give you an advice - take a close look at set analysis, especially element function E (for Excluded). An example from "help":
sum( {$<Customer = E({1<Product={‘Shoe’}>})>} Sales ) returns the sales for current selection, but only those customers that never bought the product ‘Shoe’. The element function E( ) here returns the list of excluded customers; those that are excluded by the selection ‘Shoe’ in the field Product.
I understand not wanting to download anything but that wont work unfortunatly, what the file shows is in each row there is a date/time item went offline and when it came back so what the formula needs to do is show all items where the date/time went offline is greater than date specified and date/time is less than date/time specified.
From your latest explanation, it looks simpler than I thought. No need for the set analysis (the unavailable term confused me). It is more likely a combination of conditions in if(), e.g.
if(DateTimeWentOffline>$(SelectedTime) and DateTimeCameBack<$(SelectedTime), ...)
Hope it helps. If not, I'll download your file - but only if you upload it right here.
