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
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
[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
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
It seems to be ok thanks