Help creating a specific kind of table layout

[stjack99]

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.

[steveyz · Accepted solution]

... | eval Month = strftime(_time, "%b") | chart count by Thing Month

[stjack99]

Thanks... I was way over thinking this...