Splunk Search

using tstats with a datamodel

rettops
Path Finder

I'm trying to use tstats from an accelerated data model and having no success. I took a look at the Tutorial pivot report for Successful Purchases:

| pivot Tutorial Successful_Purchases count(Successful_Purchases) AS "Count of Successful Purchases" sum(price) AS "Sum of Price" SPLITROW productName AS "Product Name" SPLITROW price AS "Price" SORT 100 productName

In the search.log for that report, it says that eventSearch is:

tstats count AS "Count of Successful Purchases" sum("Purchase_Requests.price") AS "Sum of Price" from datamodel="Tutorial" where (nodename="Purchase_Requests") (nodename="Purchase_Requests.Successful_Purchases") groupby "Purchase_Requests.productName" "Purchase_Requests.price" prestats=true

I tried doing that and get 'No results found'. Even

tstats count from datamodel="Tutorial"

gives no results. What am I doing wrong?

1 Solution

rettops
Path Finder

Duh ... add a pipe to the beginning and strip off the "prestats = true" and suddenly I get results.

View solution in original post

rettops
Path Finder

Duh ... add a pipe to the beginning and strip off the "prestats = true" and suddenly I get results.

Get Updates on the Splunk Community!

Index This | What did the zero say to the eight?

June 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...

Splunk Observability Cloud's AI Assistant in Action Series: Onboarding New Hires & ...

This is the fifth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Now Playing: Splunk Education Summer Learning Premieres

It’s premiere season, and Splunk Education is rolling out new releases you won’t want to miss. Whether you’re ...