Appointments: IDMS_JC where U_IDMS_Type == Appointment and CreateDateTime in between now and start of the year before today (01/01/2021).

  • AppointmentsCurrent: from the Appointments above we keep the entries with CreateDate in the selected time frame (YTD, QTD, MTD).

Calculations

  • We store the count of each Source of the AppointmentsCurrent and we present the one with the max count.
  • No labels
Write a comment…