Splunk Search

Help creating a specific kind of table layout

stjack99
Explorer

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.

Tags (1)
0 Karma
1 Solution

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

View solution in original post

0 Karma

steveyz
Splunk Employee
Splunk Employee
... | eval Month = strftime(_time, "%b") | chart count by Thing Month
0 Karma

stjack99
Explorer

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

0 Karma
Get Updates on the Splunk Community!

Technical Workshop Series: Splunk Data Management and SPL2 | Register here!

Hey, Splunk Community! Ready to take your data management skills to the next level? Join us for a 3-part ...

Spotting Financial Fraud in the Haystack: A Guide to Behavioral Analytics with Splunk

In today's digital financial ecosystem, security teams face an unprecedented challenge. The sheer volume of ...

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability As businesses scale ...