Order BY Date field KIBANA Lens visualization ordered by alphabetically


I created a lens visualization in Kibana. I visualize data in tabular form like excel. When I set order on a date type field (date format like March-2023) it is not showed in correct order.
Like Jan-2023, Feb-2023, Mar-2023, Apr-2023.
It ordered it in alphabetically like Apr-2023, Feb-2023, Jan-2023, Mar-2023.

Have any solution for it or some trick to show data ordered by a date field in correctly.

Thanks in Advance,
Vikram Singh

Hi @vikram_singh

if your rows dimension is a date histogram then it should already be sorted correctly (as it inherits the data order from ES response).
Can you share the configuration of your Lens table, maybe I'm missing something.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.