Forum Discussion

MEDFAR's avatar
MEDFAR
Cloud Apps
01-06-2023

How can you Count the number of patient with more than one AppointmentId in the same day

Hello, I've been trying to build build a widget (NUMBER) where I get the total Count of PatientId  with more than one appointment in the same day... I was able to build a pivot table but I am confuse...
Code-first Analytics
harikm007's avatar
harikm007
Data Warehouse
01-08-2023

Hi MEDFAR ,

Try CASE statement to check if number of AppointmentId is greater than 1 within multipass aggregation.

The formula would be something like this:

(SUM([PatientId], 
case when (COUNT([AppointmentId]), [AppointmentDate]) > 1 
  then 1 
  else 0 
end)

-Hari