Splunk Search

help to display fields in a table

Contributor

HI
I use the search below in order to count errors by Product and source
TOTO
(Source="Hang" OR Source="Error")
| search Product=*
| stats count as count by Product Source

But what I need is to display the colum like this :
Product Hang Errors count
I have tested with transpose but it doenst works
thanks for your help

Tags (2)
0 Karma
1 Solution

Champion

How's this?

(Source="Hang" OR Source="Error")
| search Product=*
| stats count(eval(Source="Hang")) as Hang,count(eval(Source="Error")) as Error,count  by Product

View solution in original post

0 Karma

Influencer

[updated]: Are you looking for something like this? If you also need total count.

Product      Hang       Errors     count
x              5          10         15
y              2           0          2

If yes, then you can use xyseries:

(Source="Hang" OR Source="Error") Product=*
| stats count by Product Source
| xyseries Product Source count
| fillnull value="0"
| eval count = Hang + Error
0 Karma

Champion

How's this?

(Source="Hang" OR Source="Error")
| search Product=*
| stats count(eval(Source="Hang")) as Hang,count(eval(Source="Error")) as Error,count  by Product

View solution in original post

0 Karma

Contributor

It seems to be ok thanks

0 Karma