Hello experts,
I am following https://www.elastic.co/guide/en/kibana/master/canvas-function-reference.html
to create a single data table from two queries. Attached a screenshot of the same page below.
However, in my case the individual queries returns multiple rows as I am using "select count(*)...group by department, class ..." in my queries. In this example above when I try to implement I get just one row in the final table. If I use the rowCount = 10, the same raw gets repeated 10 times.
My question is how do I get all the rows from the queries and combine it into one table ?? instead of just one row ?
e.g.