I am wanting to timechart total logins, login failures, and failure rate on a mult-axis graph. So time across the bottom, with total logins/login failures stacked and shown on 1 y-axis, and the failure rate percentage on the other y-axis. I can calculate the 3 values with the following search ... just not sure how to do the timechart with multi-axis for the logins and percentage series.
index=logins | stats count(eval(Login_Result="FAILED")) AS failed, count(eval(Login_Result)) AS total_logins | eval failure_rate=((failed/total_logins)*100) | eval failure_rate=round(failure_rate,2)
index=logins | bin _time span=10m | stats count(eval(Login_Result="FAILED")) AS failed, count(eval(Login_Result)) AS total_logins by _time | eval failure_rate=round(((failed/total_logins)*100),2)
This should give you some time-based data to graph with. A Column Chart might work.