Kibana Canvas Pie Chart showing data from two different queries

Elastic Stack Kibana
1

Hi everybody!

I have two tables where I have opposite results that I'd like to see together in some chart (Pie Chart if possible :smiley: )

The queries are almost the same:

| essql query="select num1.keyword from dataframelast where suffix.keyword in ('mt','dn') group by num1.keyword having count (distinct suffix.keyword) = 2"

| essql query="select num1.keyword from dataframelast where suffix.keyword in ('mt','dn') group by num1.keyword having count (distinct suffix.keyword) = 1"

Sn%C3%ADmek%20obrazovky%20(71)
Snímek obrazovky (71).png1595×779 65.8 KB

Is it possible that each result would have different colour and I can see number or percentage of each?

Do you have any suggestion for element which could solve that?

Thank you for any replies in advance!

2

It's not currently possible to feed a chart from multiple queries, in part because there's no row union function yet. So the SQL query should be set up such that a single query can return the requisite input.

3

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