Here need to get the recent date when the field pipeline stage has a value opportunity else the date should be null.
Click on result tab and under columns select Formula(Date) :
Summary Type : Maximum
Description : coalesce(max( case when{systemnotes.field} in (‘Pipeline stage’) AND {systemnotes.newvalue} in (‘Opportunity’) then {systemnotes.date} end),Null).
available filter : Internal Id