So this is probably me not understanding how pivot works, but I am trying to build a pivot table, but it comes back with 0 results. If I click the 0 in the statistic table view of the create new pivot it takes me to a search view which clearly has results.
Am I misunderstanding how pivot is supposed to work? If the underlying search has results, why does the pivot show 0? especially when all I'm trying is for a basic count.
This can't be answered without more specific information. What is in the data model? What is the search underlying the Pivot search you see when you click through to open it in search? What do you expect to happen? How are you trying to visualize the Pivot in a chart or table? If a chart, what kind? Are you trying the wrong kind of chart for the type of results you have (multi-modal results but using a single result chart style)?
Please give us more to work with so we can have enough information to help you find a solution.
If you haven’t seen it yet, you might want to check out the Splunk reference app with associated developer guidance that was built by a Splunk dev team. The current version covers app development topics from getting your data into Splunk Enterprise to building custom reporting through testing and packaging your app. There’s code and tests you can use and the development process is fully documented. The book is available in both paperback and Mobi from Amazon.
This is an ongoing dev effort by the team so check back often to see what’s been added. Also, feel free to post requests for future improvements and even contribute by reporting bugs or submitting pull requests.