ASRs: IDMS_ASR_LOG with DeferredStatus == Ordered and CreateDate in between now and start of the year before today (01/01/2021).

JCs: IDMS_JC with CreateDateTime in between now and the start of the year before today (01/01/2021).

  • ASRsCurrent: from the ASRs above we keep the entries with CreateDate in the selected time frame (YTD, QTD, MTD).
  • ASRsPrevious: from the ASRs above we keep the entries with CreateDate in the time frame (PYTD, PQTD, PMTD).
  • 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).

Calculations

  • CurrentRate: If ASRsCurrent count > 0 and JCsCurrent count > 0 then ASRsCurrent count / JCsCurrent count.
  • PreviousRate: If ASRsPrevious count > 0 and JCsPrevious count > 0 then ASRsPrevious count / JCsPrevious
  • PercentageChange: If the PreviousRate is > 0 then (CurrentRate – PreviousRate) / PreviousRate.
  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.