I defined two eventypes: "loginAttempt" and "loginSuccess". Now I am trying to create a chart where counts of both of these events are displayed side by side, per hour, to create a visual representation of the gap between attempted vs successful logins for each hour.
Tabular representation would be something like:
Date | Hour | Count of Attempts | Count of Successful
I got individual counts working, but having a hard time figuring out how to combine the two while adding them up per hour. Any help is greatly appreciated.
Try something like this
| timechart span=1h count by eventtype
Thank you, looks like I was overthinking it...