8 Replies Latest reply on Jan 30, 2017 8:37 AM by Andrew Whittam

    Using Indices to compare profiles

    Andrew Whittam

      Hi, I am an absolute newbie with Tableau! Impressed so far but have hit a brick wall.

       

      I have an Age profile of people buying product A, B and C.

       

      I want to understand if, by product, if the customers are more/less likely to have certain age profiles. To do this in xl I simply create indices...

       

      The indices which are how the column % of a products Age group compares to the total for that age band for all products.

       

      From the index we can understand if that age group is over/under (>100 or < 100) represented for the product.

                                                                                                                                                                                                                          

      AgeCustomer Count Col % Index
      ABCTotalABCTotalABC
      Under 18         677         294         378         1,3492.6%0.9%1.7%1.7%153%56%98%
      19-25         7,278       7,697       5,955       20,93027.8%24.8%26.1%26.1%106%95%100%
      26-40       11,275       9,756       7,721       28,75243.0%31.4%33.8%35.9%120%88%94%
      40-60         4,341       2,530       1,743         8,61416.6%8.1%7.6%10.8%154%76%71%
      61-75         1,107         860         872         2,8394.2%2.8%3.8%3.5%119%78%108%
      76+         5,471       2,319       1,657         9,44720.9%7.5%7.3%11.8%177%63%62%
      Total       30,149     23,456     18,326       71,931115.1%75.5%80.3%89.8%128%84%89%

      Does anyone know how I can do this in Tableau?

       

      Thanks

       

      Andrew

      Insight Analyst

      London Borough of Bexley