1 Reply Latest reply on Jan 14, 2013 4:57 PM by Tracy Rodgers

    What is the syntax for selecting more than one filtering criteria (similar to pivot tables)?

    stephanie.kumar

      Hello there -

       

      I'm looking to recreate a pivot table-like function in Tableau through a calculated field, but am unable to find the answer in this community discussion. In sum, I want to find the aggregated number of VISITS for users who are in a specific SEGMENT i.e. "Test" AND who also visited a specific DOMAIN i.e. "website1.com."

       

      Data has following format:

       

      SEGMENT |    DOMAIN    | VISITS

      Test          | website1.com | 35

      Control      | website2.com | 567

      Test          | website2.com | 18

      Test          | website1.com | 842

      Control      | website1.com | 900

      ...

       

      The end goal is to aggregate the different cuts of data and then create an index of TEST v CONTROL for each DOMAIN (example output below).

       

      Index of TEST v CONTROL for website1.com = 101.23

      Index of TEST v CONTROL for website2.com = 104.47

       

      Thanks in advance for your help! Let me know if more information is needed.

       

      Stephanie