3 Replies Latest reply on Jan 29, 2014 7:58 AM by . Indumon

    Calculating Measure within Dimension

    Tatiana K

      I've got a Dimension say "Event" that has 2 categories Views and Purchases.  This works with my measure Values.  The data looks similar to this

      ViewsPurchases
      7525
      250125

       

      I'd like to create a rate that is Purchases / Views but can't seem to figure out how to create the calculate field in tableau.

       

      When I put just the Dimension and Measure into a table and do a table calculation of "Percent from" + "Across" I get the values I want, but I  have 2 Measures I'd like to work with and put on the same axis which seems impossible without creating a calculated field.

       

      It's basically

       

      Event = Purchase [Values] / Event = Views [Values].

       

      Any suggestions would be greatly appreciated.