Stats Values(x) command is giving unexpected results

[dheera]

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.

[yannK]

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

[lguinn2]

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