1 Reply Latest reply: Nov 9, 2018 5:45 AM by Anil Samineni RSS

    Cumulative Order Count based on 2 Dates driving by Single Date

    vinay R

      Hi All,

       

      I have 2 dates in my table and One Order ID.

       

      Load Order ID,

           Shipment_Dt,

           Complete_Dt      /*With in the same Date as Shipment or future Date to the Shipment*/

      from xyz.xlsx;

       

      Business Rules:

      1. Driving date on Dashboard - Shipment Dt.

      2. I have to Display the counts based on Shipment DT and on Complete Dt as well. (2 Different KPIs)

       

       

      1. Based on Shipment: (see the attached count) - Which is Straight Forward.

      2. Based on Complete Dt: (See the attached Count) - Need help hand on this.

       

      Requirement:

      If I select Shipment Dt as  2018-Q2 on the Dashboard, then the Order Count in 2 KPI should show as 634.

      Because it is the COUNT based on previous Shipment Dates till 2018-Q2.

       

      Start Date is always 1/1/2017 in both the Shipment & Complete Dt.

       

       

      Thanks in advance.