Splunk Search

Stats Values(x) command is giving unexpected results

New Member

Hi Team,

Stats values command in pivot(data model) is giving unexpected results. For ex below search
| pivot A_pivot B_object values(X) AS X_1 SPLITROW Y total count is C but expected count is C*2 which is very low. Please look into it. Please let us know in case you need more info.

Tags (2)
0 Karma

Splunk Employee
Splunk Employee

Are you saying that the count is low, or that the values (X_1) is low ?

Values(myfield) return the distinct list of values.

so with

A | stats values(A)

will return 1,2,3 not 1,2,3,1,2

0 Karma


There is no example given. We need a lot more data: we need to know about the object and the underlying events.

Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) v3.54.0

The Splunk Threat Research Team (STRT) recently released Enterprise Security Content Update (ESCU) v3.54.0 and ...

Using Machine Learning for Hunting Security Threats

WATCH NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more for ...

New Learning Videos on Topics Most Requested by You! Plus This Month’s New Splunk ...

Splunk Lantern is a customer success center that provides advice from Splunk experts on valuable data ...