Hello everybody, Please support with the bellow question. So, I have GUID field, which is KEY, Completed_AT( in format 'YYYY-MM-DD hh:mm:ss') and Completed_By as the name. The problem that I should have only latest date with corresponding name. But I have full history of actions.
I ve tried with FirstSortedValue and MAX, but I didn`t have big results. Also it`s necessary to set such command only in script, as these fields latter are LeftJoining into main table.