No mapping found for {field} in order to sort on for top hit metrics

Elastic Stack Kibana
1

Hi,

I am trying to create a visualization using top hit metric. But I always got warning/error say 2/30 shards failed. And when looking at the response, there are failures with reason 'No mapping found for {field} in order to sort on'.
I did choose top hit as a sub metric and select a time as the field of sort on.
Can I know what is the reason and how can I fix this?

Thanks!

2

Sometimes this happens when some of the documents in the index pattern don't have the field that you're sorting or searching on. Can you verify that all documents that are in your time range have the field it's sorting on?