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?
Duh ... add a pipe to the beginning and strip off the "prestats = true" and suddenly I get results.
Duh ... add a pipe to the beginning and strip off the "prestats = true" and suddenly I get results.