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.
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
There is no example given. We need a lot more data: we need to know about the object and the underlying events.