Why am I not seeing any statistics with my pivot table?


After linking the data, when I go to the search string, it shows the events and all the details from tags, but does not show me any statistics. Because of this, I need to create the pivot table manually for report design. I guess I am wrong somewhere in creating logic in the data model from where I am taking the information. Can anyone please tell me what is the standard procedure so the I will get the statistics also after search string query. if you provide me any sample case study it will be highly appreciable.

0 Karma


Hi vkale
look at an example of search using pivot command

example : Using the Tutorial data model, create a pivot table for the count of
"HTTP Requests" per host.

| pivot Tutorial HTTP_requests count(HTTP_requests) AS "Count" SPLITROW
    host AS "Server" SORT 100 host

For more information see the manuel Splunk-6.2.2-PivotTutorial.pdf

Get Updates on the Splunk Community!

New Splunk Observability innovations: Deeper visibility and smarter alerting to ...

You asked, we delivered. Splunk Observability Cloud has several new innovations giving you deeper visibility ...

Synthetic Monitoring: Not your Grandma’s Polyester! Tech Talk: DevOps Edition

Register today and join TekStream on Tuesday, February 28 at 11am PT/2pm ET for a demonstration of Splunk ...

Instrumenting Java Websocket Messaging

Instrumenting Java Websocket MessagingThis article is a code-based discussion of passing OpenTelemetry trace ...