Yes, please raise an Oracle SR with Customer tenancy details, we will enable the key metrics migration option as part of content bundle migration.

Screen shot example :

Yes, you can use the MAX function, derive the sample logical SQL query using Developer tool/Query Log option in OAC.

Use Logical SQL Query option to default it to CURRENT_DATE.

Excellent feature to combine multiple VOs to transform the data into a single target data warehouse table entity.