I'm trying to generate a table that is a count of things by the 12 months of the year. For instance, the chart might look like:
|Jan|Feb|Mar|Apr|...|Dec|
|Thing1| 15|102| 67|645|...| 0|
|Thing2| 0| 17|111| 15|...| 8|
|Thing3| 1|555|123|321|...|999|
etc...
I've figured out how to do this my making the output verticle; count of things in a month, followed by the count of things in the next month and so on. I want to be able to stack the months horizontally.
Thanks in advance.
... | eval Month = strftime(_time, "%b") | chart count by Thing Month
... | eval Month = strftime(_time, "%b") | chart count by Thing Month
Thanks... I was way over thinking this...