search

avniproject / Adolescent-Sewa-Rural

0 stars 0 forks source link

[SR][Operational Reports] App Monitoring/Operational Dashboard - Registrations #26

Closed nupoorkhandelwal closed 3 months ago

nupoorkhandelwal commented 4 months ago

Reports in Metabase to monitor the following by time period and location

Requirement document

https://docs.google.com/spreadsheets/d/1ZCQRQ07Q0tLj48sW3TrHn2kAYJa2z5wX/edit#gid=208134223&range=A4:A9

Type - Count Drill down - To the registration linelist Join - Address table Exclude - voided Filter field : Registration date

Type - Line list Drill down - NA Join - Address table Exclude - voided Filter field : Registration date

pkundu commented 3 months ago

@AnjaliBhagabati can you create separate cards for each of them

adamsanadi6 commented 3 months ago

Dashboard Links:

  1. Operational Dashboard
nupoorkhandelwal commented 3 months ago

@adamsanadi6 cancel visits are synced in different ETL tables. You will have to update this query to have cancelled data on dashboards. Join the cancel table with respective encounter table.

nupoorkhandelwal commented 3 months ago

@adamsanadi6 cancel visits are synced in different ETL tables. You will have to update this query to have cancelled data on dashboards. Join the cancel table with respective encounter table.