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
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
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