24 Replies Latest reply: Jun 29, 2017 2:44 AM by Andy Weir RSS

    Listing top 10 and comparison by gender

    Jess K

      Dear all


      I am working on a movie dataset and is struggling to display the following information on my dashboard.

      My database has the following columns: MovieTitle, Gender, Ratings


      I need to display the following:

      List the top 10 movies that, on average, men rate higher than women.

      I assume that we have to use a List Box for the above.

      I created a List Box with MovieTitle as the Dimension.

      I am not sure what to add to the expression such that it filters out only the top 10 movies (based on Average Ratings calculated) that men rated higher than women.

      Could someone please help to provide some clear advise.

      Thank you so much!