Splunk Search

Stats Values(x) command is giving unexpected results

dheera
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

yannK
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=1
A=2
A=3
A=1
A=2

A | stats values(A)

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

0 Karma

lguinn2
Legend

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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...