---
# System prepended metadata

title: Report Generated from querying Rainbow Instance naomedicaldb - r2_appointemnts

---

# 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
[![ss1.png](https://i.postimg.cc/ZYWmcLST/ss1.png)](https://postimg.cc/jCYBqP29)
#### fraction/percentage
[![ss2.png](https://i.postimg.cc/prrLYNBx/ss2.png)](https://postimg.cc/wRKzgGPb)
<hr>


### rescheduled appointments
[![ss3.png](https://i.postimg.cc/Vv2mqJ6B/ss3.png)](https://postimg.cc/5Q5h1N86)
#### fraction/percentage
[![ss4.png](https://i.postimg.cc/d0nFWH30/ss4.png)](https://postimg.cc/p993rBDN)
<hr>


### Count of Appointments per patient 
[![ss22.png](https://i.postimg.cc/ZKZcZ4L0/ss22.png)](https://postimg.cc/DmjsPVHK)
### Per patient cancellations and non cancellation
[![ss23.png](https://i.postimg.cc/v8Wmfswr/ss23.png)](https://postimg.cc/7bZDrj6h)


### years for appointment
[![ss5.png](https://i.postimg.cc/sDyrrCW2/ss5.png)](https://postimg.cc/YjXV6Vbc)

#### outlier/dummy record
[![ss6.png](https://i.postimg.cc/j5zFgCZ4/ss6.png)](https://postimg.cc/1n3B4Rx8)
<hr>

### yearly census
[![ss7.png](https://i.postimg.cc/nrmBYQ2n/ss7.png)](https://postimg.cc/D42S70RN)

### Monthly census ( overall )
#### 1:january ......... 12:december
[![ss8.png](https://i.postimg.cc/sgHxxgPm/ss8.png)](https://postimg.cc/K1LxsFH3)
#### Monthly for year 2021
[![ss9-2021.png](https://i.postimg.cc/fyqpXp8G/ss9-2021.png)](https://postimg.cc/dZd5cHP6)

#### Monthly for year 2022
[![ss10-2022.png](https://i.postimg.cc/W1GScxMs/ss10-2022.png)](https://postimg.cc/FYK0jWW6)

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

### Unique clinics available to book appointments
[![ss12.png](https://i.postimg.cc/J0T0X7VR/ss12.png)](https://postimg.cc/9w7c5hQk)

### Distribution clinic wise
[![ss13.png](https://i.postimg.cc/xdKdR3Dx/ss13.png)](https://postimg.cc/McpxZRGV)



### Unique Reasons for appointment
[![ss14.png](https://i.postimg.cc/fTpTQrMq/ss14.png)](https://postimg.cc/hf8q9MzV)

### Distribution of reasons for appointment
[![ss15.png](https://i.postimg.cc/VLrmgWXq/ss15.png)](https://postimg.cc/4mgDNtLy)

### Generalising reasons for appointment
[![ss16.png](https://i.postimg.cc/2jJf1LgV/ss16.png)](https://postimg.cc/kDxHZGJm)

### distribution over years
[![ss17.png](https://i.postimg.cc/zBB9BqjC/ss17.png)](https://postimg.cc/wtCW48nM)

### Daily Census of appointments creation
[![ss18.png](https://i.postimg.cc/7Y0YDNbx/ss18.png)](https://postimg.cc/GH31xGkN)

### Monthly distribution of appointment creation
[![ss19.png](https://i.postimg.cc/tTWm776V/ss19.png)](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|


[![ss20.png](https://i.postimg.cc/KvvJh00T/ss20.png)](https://postimg.cc/MXNyym2Z)

### Distribution over gender
[![ss21.png](https://i.postimg.cc/Gt9KG28Q/ss21.png)](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)
