Currently I'm using JDBC and logstash to import my SQL database into Elasticsearch. I've got three tables, which I'm putting under the same index and using a different type for each table. For ease of explanation, the types and fields look like this:
Basically, an account can have multiple users, and users can belong to multiple accounts. What I'm trying to do in Kibana is visualize how many users belong to each account using a bar chart and the type 'AccountUsers' (x-axis:AccountID, y-axis:Unique count of UserID). This is working fine, but I'd prefer the x-axis labels to be 'AccountName' instead of 'AccountID'. I've done some research, and it doesn't seem like any functionality exists to use these 'AccountID's to look up the actual account name in a different document type (In my case, 'Account') and display that instead. Can anybody suggest ways I will be able to achieve this?