I would like to calculate the average value of 30 for the above data using avg operator, and then subtract the average value from each of these data to obtain the following data.
avg (num) as deviation_num
However, running avg operator causes the aggregation to disappear and the original num is no longer displayed.
How can I perform such a calculation?
Please sign in to leave a comment.