4 Replies Latest reply on Dec 5, 2016 2:35 AM by Sean Murphy

    Count of Orders by Total Duration

    Sean Murphy

      Hello!

       

      I'm currently trying to figure out how to get the number of orders that fall within each total duration.

       

      The data I have is like this:

       

      Each order has 3 stages. Those stages durations together equal the total order duration.

      I am calculating this with: window_sum(sum([duration]))

      I put Order ID on the detail to allow the table calculation to give the proper total durations.

       

      Now I have that table calculation as the first column in this picture:

       

      The second column is COUNTD(Order ID). It's returning 1 for each row, what I want to get is 2 for the second row because there are 2 deliveries that have 20 as the total duration.

       

      Can anyone help? I've attached the workbook.