5 Replies Latest reply on Jan 10, 2019 8:31 AM by Ken Flerlage

    Distinct customers with multiple transactions to determine averages

    Rose Lawhorne

      Tableau 2018.3.2

      Issue: Customer visits office for service.  Customer can have multiple transactions during their visit.  There is a row of data for each transaction containing the customer id, wait time and a transaction time for each individual transaction or service performed.   The customer's wait time is the same for all three transactions; while each individual transaction time is different.  I need to calculate the Average Wait Time and Transaction Time for customers per day, week, month etc.  If a customer has three transactions; the same wait time is presented three times and the average is not calculated properly.  I'm sure there is an easy fix - I've tried LOD:  Include and Fixed Customer ID, but that didn't work. 

       

        

      Wait Time
      Customer 10:51:08
      Customer 10:51:08
      Customer 10:51:08
      Customer 20:47:02
      Customer 30:36:23
      Customer 30:36:23
      Customer 30:36:23
      TABLEAU AVERAGE WAIT TIME0:44:14
      REAL AVERAGE WAIT TIME0:44:51