2 Replies Latest reply on Apr 29, 2017 1:39 PM by Shivi Bhatia

    Help With Data Blending.

    Shivi Bhatia

      Hi All, I need some help with Data blending. I am adding 2 excel files in Tableau- one is Volume and the other is the ticket lifecycle.

      These are joined based one common variable as " Ticket Id". The Ticket lifecycle has variables as ticket id, resolved date and assigned date. Whereas the other which is primary data Volume has - ticket Id, Name of que, date of ticket, category, priority etc.

      Basis assigned and resolved i am able to find the ticket lifecycle and also have built a code to remove the weekends.

      However how do i show the average lifecycle per month at various dimensions which are available in primary data source. is there a way to achieve this. Adding a snapshot of data variables for reference.

       

      Adding now the Tableau file as well.