Date Format for Monthly aggregated data table

Elastic Stack Kibana
1

using Kibana 7.17.15
I am creating a data table with a monthly bucket histogram on a date field. The date column is displayed as YYYY-MM-DD. I set the date field format in the index pattern as MMM YY, but it is still ineffective in the table view. Is there any way to display the date column as MMM YY

2

Hi @nada.nasser

I've managed to reproduce the same problem.
It looks like the dataView field formatter spec is not correctly picked up by the Lens table when configured as date histogram field.
I've created an issue you can track here: [Lens] Date histogram configured field formatter is not correctly picked up on Table rendering · Issue #219911 · elastic/kibana · GitHub

For recent versions of the stack I would have proposed an alternative ES|QL approach.