Metrics Template for Pano Dossiers - Githubissues

ICPI / DIV

Organizational Material

10 stars 2 forks source link

Metrics Template for Pano Dossiers #155

Closed jb3436 closed 3 years ago

jb3436 commented 4 years ago

Example from Janice

Parent Issue in Analytics Repo https://github.com/pepfar-datim/Analytic_Workspaces/issues/633

Example of How to request metrics for dataset for dossier

Metrics to be added to the MER Quarterly datasets (all using Results):

[x] Yield: HTS_TST_POS/HTS_TST
[x] Linkage: TX_NEW/HTS_TST_POS
[x] Not Linked: HTS_TST_POS - TX_NEW
[x] Retention: TX_NET_NEW/TX_NEW
[x] LTFU: TX_NET_NEW - TX_NEW
[x] PMTCT_ART Coverage: PMTCT_ART, N/PMTCT_ART, D
[x] PMTCT_STAT Coverage: PMTCT_STAT, N/PMTCT_STAT, D
[x] PMTCT_STAT Missed: PMTCT_STAT, D - PMTCT_STAT, N
[x] TB_ART Coverage: TB_ART, N/TB_ART, D
[x] TB_STAT Coverage: TB_STAT, N/TB_STAT, D
[x] TB_STAT Missed: TB_STAT,D - TB_STAT, N
[x] VL Suppression: TX_PVLS,N/TX_PVLS,D
[x] VL non-suppressed: TX_PVLS,D - TX_PVLS,N

Additional derived metrics below are from all OU dossier:

[x] Percent to Total (HTS_TST_POS) 1: HTS_TST_POS/(HTS_TST_POS){[Operating Unit]}
[x] Percent to Total by Columns (HTS_TST_POS) 1: HTS_TST_POS/(HTS_TST_POS){@cols}
[x] Percent to Total (Contacts tested): [Contacts tested]/([Contacts tested]){[Operating Unit]}
[x] Percent to Total (Contacts tested) 1: [Contacts tested]/([Contacts tested]){[Operating Unit]}
[x] Percent to Total (TX_NEW) 1: TX_NEW/(TX_NEW){[Operating Unit]}
[x] Percent to Total (TX_CURR) 1: TX_CURR/(TX_CURR){[Operating Unit]}