Need to create a dashboard

[prabhu7720]

Hi,

I'm able to get the count for NumberFormatException but the NumberFormatException is displayed in separate column. Please verify the screenshot. You will be able to understand.
I need to move the NumberFormatException and its count under Technical error. Could you please help me on this.

[richgalloway · Accepted solution]

Replace appendcols with append.

[prabhu7720]

Hi

The count value is moving to new row, but NumberFormatException is not moving under technical error

Technical_Error count NumberFormatException
CHASE_VALIDATION_FAILURE 1

UNEXPECTED_FAILURE 5

62

[richgalloway]

Here's a slightly ugly workaround.

... | append [ ... | stats count | eval Technical_Error = "NumberFormatException" ]

[prabhu7720]

it works.

Thank you 🙂

[richgalloway]

Please provide a mock-up of the expected output.

[prabhu7720]

The expected output should be as below.

Technical_Error count
CHASE_VALIDATION_FAILURE 1
UNEXPECTED_FAILURE 5
NumberFormatException 62