5 Replies Latest reply on Sep 28, 2018 8:23 AM by swaroop.gantela

    Average of a measure across all values of a dimension

    Ian Phipps

      I am creating visualizations for the analytics data of a racing game.

       

      What I want to know is this: out of all the races on a given track, how often are players achieving 1st place, 2nd place, etc.?

       

      Above, you can see that I am counting the number of times each place was achieved on each track. However, players can choose their tracks and tracks unlock slowly over time, so some tracks will naturally have a higher number of races in general, which makes it difficult to compare the 1st place values of each track to the other tracks.

       

      Looking at the top value on the y-axis, "BeachB", you can see that there are 51 1st place races. What I'd like to see here instead is that number over the total number of races in BeachB: [1st] / ( [1st]+[2nd]+[3rd]+[4th]+[5th]+[6th]+[7th]+[8th] ) = 51/119 = 0.43

       

      The values I need to see for BeachB are: 0.43, 0.18, 0.13, 0.06, 0.06, 0.07, 0.03, 0.04

       

      I found this post, which DOES NOT solve my problem:

      https://kb.tableau.com/articles/HowTo/calculating-percent-of-total-for-aggregations-by-a-dimension-across-that-dimension