Problem with first selected value

[peterderrington]

So I have a chart that shows the first instance of someone entering (and leaving) a department which uses these expressions:

Time(FirstSortedValue([Time Event Sent For],ID,1))

Time(FirstSortedValue([Time Event Out Of Recovery],-ID,1))

However the chart only works if I don't filter down to a specific department which isn't helpful.

Can anyone help?

[peterderrington]

Ok, 

Try this....

[sunny_talwar]

So, I added Theatre Name dimension to the chart (after converting it to a straight table) and I see all Nulls, seems like Theatre Name is not connected to Date of Visit dimension.

[peterderrington]

Strange, 

Here is a version of the data