3 Replies Latest reply on Sep 12, 2017 10:28 AM by Hari Ankem

    Counting the number of orders in a minute/day

    Eze Nwa

      Hi Guys,

       

      I have a challenge.
      I have a massive dataset with details of customer orders including the date and time the order was placed (Customer name, Order ID & Order Date Time)

       

      A customer can either place one or multiple orders in a minute and/or in a day across multiple products.

       

      I will like to use Tableau to determine:

      1. Time between orders
      1. Days between orders
      2. Number of orders in a day

       

      Please find attached a Tableau workbook with a mock up sample of the data in Tableau v10.2

       

      I can do this calculation in excel but the dataset is massive that I can't even load into Excel. I will so much appreciate your help with this.

       

      Thanks

      Eze