5 Replies Latest reply on Jan 28, 2016 3:21 PM by pooja.gandhi

    Percent of total from value in Dimension

    minh.nguyen.3

      Hi there,

       

      I have a large table of data that has the following structure -

       

      Date
      User Attribute
      Count
      1/1/16Web Session50
      1/1/16Purchase30
      1/1/16Active100
      1/2/16Web Session50
      1/2/16Purchase40
      1/2/16Active90

       

      I'm trying to create a calculation that displays % of total Active based on whether they had a web session or purchase.

       

      For example ideally the data would be structured like this in Tableau

       

      Date
      1/16/161/2/16
      Web Session50% (50/100)55% (50/90)
      Purchase30% (30/100)44% (40/90)

       

      I want to see what % of users are actually engaging on our website. I am able to do a full percent of total however it calculates it from all parts of the 'User Attribute' column whereas I want to calculate the percent of total from a value within that dimension.

       

      I've searched through the forums and haven't found a request that leverages data within a dimension. Any ideas?

       

      Message was edited by: Minh Nguyen