Lens unable to use any operator aside from "Unique count" on date fields in Lens Tables

[fssup]

Kibana version: 7.15.2

Elasticsearch version: 7.15.2

Server OS version: Ubuntu 18.04.6 LTS

Browser version: Chrome Version 96.0.4664.45 (Official Build) (64-bit)

Browser OS version: Windows 10 Pro 21H1

Original install method (e.g. download page, yum, from source, etc.): Debian package through APT as described in the manuals here

Describe the bug:
Cannot use any operators aside from "Unique count" on date fields in Lens Tables, eg "Last value".

Steps to reproduce:

1. Create Lens visualisatoin
2. Select Table visualisation type
3. Rows -> Add Top values of some identifyer (UUID of some server in our case)
4. Metrics -> Attempt to add "Last value" of the @timestamp field (
5. This throws an error in the UI stating This field does not work with the selected function.
   

Expected behavior:
I expect to be able to display the "Last value" of a date field in a Table visualisation in Lens to show the timestamp of the latest document matching all filters, group, etc.

Screenshots (if relevant):

Errors in browser console (if relevant):
Not relevant as far as I'm aware.

Provide logs and/or server output (if relevant):
Not relevant as far as I'm aware.

Any additional context:
I'm attempting to display a table with a row for every keyword of a field (UUID of some server in our case) and then display the timestamp of the last document on that row.
It is possible to do this in a Visualisation, and I cannot find any documentation on why this should not be possible in Lens (except for that the UI won't let me). Maybe related to What operation can you do with what types of field? over at #81780?

[elasticmachine]

Pinging @elastic/kibana-vis-editors @elastic/kibana-vis-editors-external (Team:VisEditors)

[flash1293]

Agreed, we should really support this, I will add it to the short term list. Duplicate of #104787