Can I merge these two tables as one and calculate the ratio with Kibana?
What I have now:
The left table and the right table have similar columns like ad title, ad provider, ad institution, but they are different in the last columns, one is ad impression and another is ad click.
However, ad impressions are calculated from index A and ad clicks are calculated from index B.
How can I put ad impression and ad click into one table and then calculate click/impression rate?
What I want to make: