Hi guys!!
I have this search:
index=temp sourcetype=sdc cs_host="*mto.ree.*" WT_dl=0 NOT (cs_uri_stem ="*/es-es/paginas/inicio.aspx" OR cs_uri_stem =*/results.aspx* OR cs_uri_stem =*/_layouts/* OR cs_uri_stem =*/_catalogs/* OR cs_uri_stem =/personal* )
| fillnull value="Sin Título" WT_ti
| top limit=0 WT_ti, cs_uri_stem,WT_device
| eval WT_ti= urldecode(WT_ti)
| eval percent = round(percent,2)
| eval Escritorio= if(WT_device=="Escritorio",count,0)
| eval iPhone= if(WT_device=="IPhone",count,0)
| eval iPad= if(WT_device=="IPad",count,0)
| eval Otros= if(WT_device=="Linux",count,0)
| eval WT_ti = if (WT_ti== "Mi perfil - Noticias", "Mi perfil - Novedades",WT_ti )
| rename WT_ti as Titulo,cs_uri_stem as URL, count as "Paginas_Vista", percent as "Porcentaje_%"
| search Titulo=Comunidades
Attach an image of results, my problem, I need not show de Column WT_device and show the results in a single line. It's possible?
Thanks for you time!!
... View more