topic Pie chart from multiple queries in Dashboards & Visualizations

Pie chart from multiple queries

shreyad — Tue, 03 Jul 2018 19:46:22 GMT

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?

Re: Pie chart from multiple queries

pradeepkumarg — Tue, 03 Jul 2018 19:59:42 GMT

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

Re: Pie chart from multiple queries

PowerPacked — Tue, 03 Jul 2018 20:37:52 GMT

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