stacked column chart for three values

[SanthoshSreshta]

Hi All,

I have generated a dashboard with column chart using Query: sourcetype="Churn Data_CSV" Churn="True." | stats count(Churn) as "Churn Count" by state |sort - "Churn Count" |head 10

In the above query I used only Churn="True" but now I want to get for TRUE and FALSE for every state showing in stacked column chart.
Can anyone help me out please.?

Regards,
Santhosh S.

[SanthoshSreshta · Accepted solution]

Got my answer 🙂

sourcetype="Churn Data_CSV" | stats count(eval(Churn="True.")) as True, count(eval(Churn="False.")) as False,count(eval(Churn="")) as Empty by state | sort - True| head 10