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.
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
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