Get Column Average

Question & Answer
,
1

I have a column that I created using calc field

Rating:
ifelse(
${EpisodeFilter} = ‘Episode 1’ , {Ep1 Rating TB}
, ${EpisodeFilter} = ‘Episode 2’ , {Ep2 Rating TB}
, ${EpisodeFilter} = ‘Episode 3’ , {Ep3 Rating TB}
, ${EpisodeFilter} = ‘Overall’ , {Overall Rating TB}
, NULL
)

Now, I want the average of the column… I figured QS does not have a direct way to get row/column average and I need to use AvgOver (LAC-W) function… so, I created another calc field

avgOver(
{Rating}
, [{Partition By fields}, {…}, {…}]
, POST_AGG_FILTER
)

and when I place this avg field in the view it gives the same result as rating field… what am I missing here?
image

I tried sum(rating) in avgOver but it throws error that it is not allowed.

2

If you want it over the whole column you shouldn’t partition it by anything.

avgOver(
{Rating}
)

1 Like
3

That worked, thanks Max!