Can't display average in Tableau

Question

I'm trying to display the average of movie ratings based on a common actor. When I drag and drop the "score" value in the columns, Tableau assumes I'm talking about SUMs and shows them accordingly and every square is a movie score:

But when instead of SUM I select Average, it still shows some kind of SUM but this time every little brick is the same value of average:

What am I doing wrong? Why is it showing the average once for each row instead of once for actor?

Answer 1

Your problem should be caused by the view's context, which includes Actor and Movie.

To get the average rate of each actor this should work

{ FIXED [Actor]: AVG([Rating]])}

and the following if you want the overall average rate

{ FIXED : AVG([Rating]])}

If you want a better understanding of context and Level of detail expressions you can start reading this.