Search active patient by their characteristics.

Clinically important Characteristics for Filter

• Latent Characteristics (summary variables created)
  • High Risk group
  • Referred to Hospital Group
  • Referred to Doctor Consultation
• Observation and Conditional characterstics
  • Co-morbidity
  • Medication
  • SPO2
  • Temperature
  • Respiratory Rate
  • Heart Rate

Administrative Characteristics for filter

• Date (? enrollment or ?active )
• District
• Municipaltiy

Summary Indicators

• Total active cases
  • categorized by gender
  • categorized by Age

Patient list Table

This should be with function to export, sort and filter

Patient Charactrization Table Design

Codes

Create URL for View Report

HYPERLINK(
	CONCAT("<https://datastudio.google.com/u/1/reporting/9374fe2f-2222-40bf-9fbc-31214b8fe46f/page/BwVsB?params=%7B%22df67%22:%22include%25EE%2580%25801%25EE%2580%2580IN%25EE%2580%2580",t0._2243688_"%22%7D>"),
"View Report")

Google Sheets