TX.08: VL Coverage Age/Sex

USAID-OHA-SI / OHA-Tableau-Dashboard-QA-QC

This repository will be used to track the QA/QC process for OHA Tableau Dashboards

0 stars 1 forks source link

TX.08: VL Coverage Age/Sex #64

Closed jaliasd closed 5 years ago

jaliasd commented 5 years ago

Folks, I'm not sure where to look on pano to QC this. The instructions say look at the “Treatment Continuum & Net New Visuals” Dashboard but when I do there isn't anything by age/sex see here

I tried looking at the Viral Load (OU level) but that didn't have age/sex breakdowns other than at the PSNU level and that wasn't by agency (same link). So I don't know where to look to QC this.

gsarfaty commented 5 years ago

One option is to look at the age/sex disaggregates dashboard in Panorama, filtering indicators to just TX_CURR & TX_PVLS.

jaliasd commented 5 years ago

Ok Update, I did as @gsarfaty said and compared the TX_PVLS N and D values for two OUs against tableau. I had to hack the tableau dashboard to remove the sex filter to match Pano output. The values matched in both cases so I'm going to mark this done. I'm not sure where TX_CURR comes into play here. The % shown in the both dashboards are just TX_PVLS N/D. Thoughts?

gsarfaty commented 5 years ago

For tab TX.08: VL Coverage Age/Sex the % is calculating the proxy coverage as defined by TX_PVLS D/TX_CURR.

The tooltip needs to be updated as it is only displaying the denominator of the calculation (TX_CURR) & is labeled as showing retention:

jaliasd commented 5 years ago

When I do the export excel from TX.08: VL Coverage Age/Sex, I only get the below

When I look at the other tab

jaliasd commented 5 years ago

"Resolved" user error. Instructions need to be updated.

noahbartlett commented 5 years ago

Tooltip issue fixed.