Dear Team,
I have data in this format, as shown in actual and expecting results as shown in expected. Is this achievable? May i request your heIp?
@syjayaraj
Can you please try this?
YOUR_SEARCH
| table Label Value OID | chart values(Value) as Value over OID by Label
Sample Search:
|makeresults | eval data="Admin Status|2|505,SSH|2|505,Serial Number|FYUUU5|505,Admin Status|2|506,SSH|2|506,Serial Number|FYUUU6|506" | eval data =split(data,",") | mvexpand data | eval Label=mvindex(split(data,"|"),0),Value=mvindex(split(data,"|"),1),OID=mvindex(split(data,"|"),2) | table Label Value OID | chart values(Value) as Value over OID by Label
Thanks
@syjayaraj
Have you tried this?
hi @syjayaraj
try below,it is helped pls accept answer 🙂
|makeresults |eval Label="Admin status" ,Value=2,OID=505 |append [|makeresults |eval Label="SSH" ,Value=2,OID=505]|append [|makeresults |eval Label="Serial number" ,Value="FYUUU5",OID=505]|append [|makeresults |eval Label="Admin status" ,Value=2,OID=506]|append [|makeresults |eval Label="SSH" ,Value=1,OID=506]|append [|makeresults |eval Label="Serial number" ,Value="FYUUU6",OID=506] |table Label Value OID |chart values(Value) over OID by Label