# Report Generated from querying Rainbow Instance naomedicaldb - r2_appointemnts

## Count refects number of appointments
### *Appointment_Date implies "date for which appointment is to be"*
### *CreationDate implies "date on which appointment is created"*
### Number of clicks - assuming as a trigger from book appointment button creates an entry in row - creation_date entries possibly means the number of clicks on appointment button
##### *Note : in this instance there are 693 unique patients who have a unique customer_uid associated with them and total appointments : 4022*
# Screenshot after querying

### cancelled appointments
[](https://postimg.cc/jCYBqP29)
#### fraction/percentage
[](https://postimg.cc/wRKzgGPb)
<hr>

### rescheduled appointments
[](https://postimg.cc/5Q5h1N86)
#### fraction/percentage
[](https://postimg.cc/p993rBDN)
<hr>

### Count of Appointments per patient
[](https://postimg.cc/DmjsPVHK)
### Per patient cancellations and non cancellation
[](https://postimg.cc/7bZDrj6h)

### years for appointment
[](https://postimg.cc/YjXV6Vbc)

#### outlier/dummy record
[](https://postimg.cc/1n3B4Rx8)
<hr>

### yearly census
[](https://postimg.cc/D42S70RN)

### Monthly census ( overall )
#### 1:january ......... 12:december
[](https://postimg.cc/K1LxsFH3)
#### Monthly for year 2021
[](https://postimg.cc/dZd5cHP6)

#### Monthly for year 2022
[](https://postimg.cc/FYK0jWW6)

### Hourly Distribution for appointments ( could be done for any date )
#### overall:
[](https://postimg.cc/dh7mbN2y)

### Unique clinics available to book appointments
[](https://postimg.cc/9w7c5hQk)

### Distribution clinic wise
[](https://postimg.cc/McpxZRGV)

### Unique Reasons for appointment
[](https://postimg.cc/hf8q9MzV)

### Distribution of reasons for appointment
[](https://postimg.cc/4mgDNtLy)

### Generalising reasons for appointment
[](https://postimg.cc/kDxHZGJm)

### distribution over years
[](https://postimg.cc/wtCW48nM)

### Daily Census of appointments creation
[](https://postimg.cc/GH31xGkN)

### Monthly distribution of appointment creation
[](https://postimg.cc/sQfJNjwV)

## Age Distribution

| Age Group | Age Range |
|---|---|
| minors | <=12 |
| teenagers | [13,19] |
| young adults | [20,30] |
| adults | [30,40] |
| middle-aged | [40,50] |
| seniors | [50,60] |
| old | >=75|

[](https://postimg.cc/MXNyym2Z)

### Distribution over gender
[](https://postimg.cc/K3Stym5k)

<hr>

# Other reports like census for each site where encounters with status = 'CHK' or 'FTR' or 'ER' are being done on healthjump and Census 2022 automated is available at [Census Dashboard](http://dbx.healthjump.com/public/dashboards/kfhrjvRn3rFqyDOdYT2qQCU5LzHD8fEf5ktKZn8Y?org_slug=default)