Could you provide a full recreation script as described in About the Elasticsearch category. It will help to better understand what you are doing. Please, try to keep the example as simple as possible.
A full reproduction script will help readers to understand, reproduce and if needed fix your problem. It will also most likely help to get a faster answer.
Please provide it as a Kibana script which can be run in the Dev Console not as Java code. Once we will have a working script, we can translate it to java.