Struggling with aggregation of terms using values from another field

Hi all, I have one field in my index which contains engineers names, and another field which contains ticket notes - and also within the notes text are the engineers names. I need to count how many records each engineer has with his name in the notes field. What is the best to achieve this ? As engineers come and go and did not want to reference specific names in a query if I can help it - hence why I wanted to refer to the field called 'engineer' instead to use those names in the aggregation if that makes sense.

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