topic Custom text - Table in Dashboards & Visualizations

Custom text - Table

mahesh27 — Tue, 23 Jul 2024 20:16:18 GMT

index=testindex source=application.logs |rex "ErrorCode\:\[?<Error_Code>\d+]" |search Error_Code IN(200, 500, 400, 505, 500) |stats count by Error_Code |Where count > 5

output:

Error_Code	count
200	20
500	100
400	40
505	45
500	32

Instead of Errorcodes we want to display a custom text as shown below.
How can we do this??

Expected output:

Error_Code	count
Application received with errorcode 200	20
Application received with errorcode 500	100
Application received with errorcode 400	40
Application received with errorcode 505	45
Application received with errorcode 500	32

Re: Custom text - Table

richgalloway — Tue, 23 Jul 2024 20:42:12 GMT

Use the eval command to replace the Error_Code value with the desired text.

Re: Custom text - Table

mahesh27 — Tue, 23 Jul 2024 21:08:16 GMT

hi @richgalloway , Even i tried with eval command but it did not work.
But i tried as per your query it worked, thank you.

Re: Custom text - Table

richgalloway — Wed, 24 Jul 2024 12:16:37 GMT

I don't understand the reply. Did my answer work or not? If your problem is resolved, then please click the "Accept as Solution" button to help future readers.