Is there a way the facets in Azure Search can be ordered by the highest scored document in each facet. The default approach is ordered by number of documents in each facet which not as useful when match accuracy is critical. I understand the 'sort' is within the facet- not across facets.
I am hoping that this will help solve the following need in an indirect way Azure Search- replicating result of nested SQL query