Pie chart from multiple queries

[shreyad]

I want to create a pie chart for a dashboard, but I would like each piece of the pie to be the results from separate queries. How do I achieve that?

[PowerPacked]

Hi @shreyad

I believe whole Pie is considered as 100% in which each value takes some percentage by calculating its quantity on the whole.
bringing pieces from individual queries should not be the case.

Thanks

[pradeepkumarg]

How do your individual queries look like? You can combine all your individual queries into one search and then run statistics on the result set to generate a piechart

Eg:

  mysearch1 |table field1 count | append [mysearch2 |table field1 count ] | append [mysearch3 |table field1 count] | stats sum(count) by field1