Global 03

[kgichuhi]

Global O3 QA/QC

• Exported worksheet as crosstab to excel and data matches.
• Not possible to compare to Panorama since there are no global views/datasets

Recommended Changes

1. Want to add a filter for OU to provide a menu for each OU and a PEPFAR option to show summary results
2. Want to change the visual to a horizontal bar chart so that:
3. Priority indicators are on the y-axis which each bar representing an indicator
4. Agency contribution will be indicated within each bar designated by color
5. Priority indicators should be:

• HTS_SELF
• HTS_TST
• HTS_TST_POS
• OVC_SERV
• PMTCT_STAT
• PMTCT_STAT_Newly Identified POS
• PMTCT_ART
• PREP_NEW
• TB_STAT
• TB_ART
• TX_NEW
• TX_NET_NEW
• TX_CURR
• VMMC_CIRC

This will be used by FO as part of the summary sheet request and aligns nicely with the dollar amount and % of COP funding amount by country analysis that was also requested. This contribution tab is very helpful.

[noahbartlett]

OU-specific agency by agency proportion of results are shown in another tab. This tab is designed to show an overview of the whole global program.

I have added a second version of the same tab which has what you want. I leave it to the group to decide which if either to keep.

[noahbartlett]

Added an OU filter to version 2 (bar chart) of this tab.