I have a question about Kibana and how to do calculates combinating different index with different mapping.
I want to create a graphic using TSVB or just a line chart that calculates a "Rate", but the problem is i need to use the count about two different index with different mapping.
The index 1 is a list of incidents with some fields (company, date, info about incidents, etc) and the index 2 is a list of installed base with differents fields (company, date, another info).
The Rate is just : count(incidents) / count (installed base) grouped by month in order to get a line char that shows the rate for each month in all year (January: 10%, Feb: 13%...)
So, i tried to use TSVB, and i can got both counts separated in the same graphic and grouped by months, but i can't combine them in an aggregation with Math function to calculate this Rate.
Besides, i though about create an script field, but, if im right, TSVB can`t use it.
On the other hand, char line visualization allows to use script field but not combine index pattern (if im right again)
So, how could i make this and similar calculates using combine index patterns?
I hope i have explained this as best i can.
Thanks for the help!