Combining two count select queries to create a data table in canvas essql

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.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.