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

*NEW* Splunk Love Promo!
Snag a $25 Visa Gift Card for Giving Your Review!

It's another Splunk Love Special! For a limited time, you can review one of our select Splunk products through Gartner Peer Insights and receive a $25 Visa gift card!


Or Learn More in Our Blog >>