...ename cisco_spam as spam, cisco_virus as virus,cisco_stoppedbyreputation as reputation
| transpose
The result look like:
column
row 1
reputation
740284221
rep_perc
8...
...ount by client_isp,_time | where count >= 600 | convert timeformat="%m/%d/%Y %H:%M:%S" ctime(_time) | sort - count | transpose header_field=_time
When I set this one as an alert, it considers t...
hello
I use a transpose command in order to have _time field displayed in column instead row
First question :
how to delete the header?
second question :
I was doing a color f...
Hello
As you can see in my search I transpose time in my header field
| eval time=strftime(_time,"%H:%M")
| sort time
| fields - _time _span _origtime _events
| fillnull value=0
| transpose...
...equest 20 B 200 OK 110 B 400 Bad Request 15 B 500 Internal Server Error 5 C 200 OK 85 C 400 Bad Request 25 C 500 Internal Server Error 30 But I want to get a transpose o...
Hi, I have a situation where I need to split my stats table. I have tried to use transpose and xyseries but not getting it. HAs someone had the same situation? Pls guide. Thanks!!! What I h...
...alues(request.detail.apiContext) as api by requestid
| search (api="benefits" OR api="employment" OR api="income")
| stats count by afin, api
| transpose header_field=api
I'd like the output t...
...y query is : index=blabla | table title, execTime | transpose 0 header_field=title include_empty=true The issue is transpose command aggregate all title with the same value. I won't that....
hello
I use a transpose command in a table panel
| eval time=strftime(_time,"%H:%M")
| sort time
| fields - _time _span _origtime
| transpose 0 header_field=time c...