1 Reply Latest reply on Nov 7, 2016 12:36 PM by Carlos Albuquerque

    Transpose a column when viewing underlying data.

    Carlos Albuquerque

      Please forgive me as I can't add a .twbx due to sensitive information. So I took screenshots of the data.

       

      I have a Status field that holds different dates for when actions occurred. If I have X number of tickets, when the user clicks that number and decides to view the data, I would like to show that information on single rows, returning the same exact X number of rows instead of 2x as there is now one row per status per ticket. I believe this can be accomplished by redoing the query using UNION, but is there a workaround to accomplish the same directly within tableau?

       

      Thank you

       

      image1.JPG