JCs: IDMS_JC all JobCards that are Open or Won and have CreateDateTime in between now and start of the year before today (01/01/2021).
VHCs: IDMS_JC_VehicleLine with CreateDateTime in between now and start of the year before (01/01/2021) and contain the Codes from the JCs we got above.
- JCsCurrent: from the JCs above we keep the entries with CreateDate in the selected time frame (YTD, QTD, MTD).
- JCsPrevious: from the JCs above we keep the entries with CreateDate in the time frame (PYTD, PQTD, PMTD).
- VHCsCurrent: from JCsCurrent we take all the entries that contain the codes of VHCs.
- VHCsPrevious: from JCsPrevious we take all the entries that contain the codes of VHCs.
Calculations
- CurrentRate: If JCsCurrent count > 0 and VHCsCurrent count > 0 then VHCsCurrent count / JCsCurrent count.
- PreviousRate: If JCsPrevious count > 0 and VHCsPrevious count > 0 then VHCsPrevious count / JCsPrevious count.
PercentageChange: If the PreviousRate is > 0 then (CurrentRate – PreviousRate) / PreviousRate.
0 Comments