Subtracting constant from field element-wise

[light_of_sirius]

Hello,

i have a field and i want to generate a new field that is the old field but its mean subtracted.

Example:

[1,2,3] -> [-1, 0, 1]

This is my attempt

| makeresults count=10
| eval dice_toss = random()%6+1
| table dice_toss
| stats avg(dice_toss) as tmp
| eval dice_toss_centered = dice_toss - tmp

[renjith_nair · Accepted solution]

replace stats with eventstats

| makeresults count=10
| eval dice_toss = random()%6+1
| table dice_toss
| eventstats avg(dice_toss) as tmp|eval tmp=round(tmp,0)
| eval dice_toss_centered = dice_toss - tmp