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)
... View more