hello all, relative newbie here, so bare with me.
I have a table output with 3 columns Failover Time, Source, Destination (This data is being sent over via syslog from a sonicwall)
Anyways, I would like to do a count by events by day. Below is the first 19 entries from the Failover Time column. If I do a [stats count by "Failover Time"] i just get each of the entries and a count of 1. I dont kow how to count by the DAY within the "Failover Time" field....looking at the below example you see there was 1 on 4-1, 2 on 4-2, 3 on 4-3, that's what i want in a chart.....
2015-04-01 02:13:48 UTC
2015-04-02 09:56:50 UTC
2015-04-02 13:18:25 UTC
2015-04-04 02:27:02 UTC
2015-04-04 02:27:57 UTC
2015-04-04 02:53:27 UTC
2015-04-07 11:42:01 UTC
2015-04-08 05:03:57 UTC
2015-04-09 18:13:54 UTC
2015-04-13 15:04:14 UTC
2015-04-13 18:29:59 UTC
2015-04-13 23:09:14 UTC
2015-04-16 05:00:42 UTC
2015-04-16 05:25:42 UTC
2015-04-16 05:30:33 UTC
2015-04-16 05:30:52 UTC
2015-04-16 05:47:48 UTC
2015-04-16 05:55:38 UTC
2015-04-16 05:55:57 UTC
What I would like to see is
Failover Time........................................Count
2015-04-01............................................1
2015-04-02............................................2
2015-04-04............................................3
2015-04-07............................................1
etc....
... View more