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?
I tried sum(rating) in avgOver but it throws error that it is not allowed.