Botswana HTS Deep Dive - for Steph Behel

[shazadahmed10]

Request: Need two stacked bar graphs showing FY17 age/sex disaggs by each testing modality (e.g. PITC, facility index, etc.). Graph 1 = HTC_TST and Graph 2 = HTS_POS

Three products:

1. Fy17 Image from CHIPS tool - Jasmine is creating image
2. Fy18Q1 graph to be generated from scratch - Shazad
3. The Male HTS_POS Fy19 gap tool for Bots

[shazadahmed10]

Jasmine sent them snapshots of HTS/Modality by Age/Sex

Shazad: sent them the file, no further feedback

file on sharepoint: https://www.pepfar.net/OGAC-HQ/icpi/Shared%20Documents/COP%20Support/COP18/Support%20Requests%20and%20Tracker/Visualizations/Botswana/Bots%20HTS%20modality%20by%20age.sex%20grpah%2018q1.xlsx

[shazadahmed10]

feedback received from Stephanie:

Can I ask you change this visual to show the age/sex distribution overall for each modality. The visual you shared has side-by-side graphs for males and females.

[shazadahmed10]

completed request...replicated same visual for Fy17APR as well. added slicers and encouraged use of slicers so not to display too much info at once

link to sharepoint:

https://www.pepfar.net/OGAC-HQ/icpi/Shared%20Documents/COP%20Support/COP18/Support%20Requests%20and%20Tracker/Visualizations/Botswana/Bots%20HTS%20modality%20by%20age.sex%20grpah%2018q1%20and%20Fy17.xlsx

[shazadahmed10]

Update:

What we wanted was to use this to figure out which modalities are identifying the most e.g. 20-29-year-old men. To do that, the male and female results have to be stacked in the same bar, not side by side.

[shazadahmed10]

Adjusted the visuals to achieve the previous comment.

Link to tool:

https://www.pepfar.net/OGAC-HQ/icpi/Shared%20Documents/COP%20Support/COP18/Support%20Requests%20and%20Tracker/Visualizations/Botswana/Bots%20HTS%20modality%20by%20age.sex%20grpah%2018q1%20and%20Fy17_V2.xlsx

[shazadahmed10]

no more feedback received