0 - 2 of 2 tags for ordered analytic function

I have run into a perplexing little problem. I know how to work around it, but want to understand the reason it is occuring.

 

 

 

When I use the FIRST_VALUE function on a date as below, it returns two rows: