PAWS 2nd 90 Home Stretch

[imujawar]

1. The formula for normalizing data: The difference of value from the minimum divided by the range.

The estimated value should be between 0 and 1. [Value – min(Value)]/[max(Value)-min(Value)] I tried using the following formula, but I don’t think it’s working correctly: (Value-Min(Value))/(Max(Value)-Min(Value))

2. Please see below the chapter and page number of the issues I encountered.

• Stacked Bar issue, where unable to have same scale for both target and result [Chapter 4, Exp: pg1 Quarterly Performane Trends]. It’s the last page on Chapter 4.
• Normalization calculation. [pg3 Quarterly Run Charts]
• Selectors for metrics such as Linkage, Yield, etc. along with indicators, if possible [pg3 Quarterly Run Charts]
• PPR styled bar charts, the difference for target in TX_CURR and NET_NEW as null instead of being equal to TX_CURR. [Exp: pg1 TX_CURR PPR trends]

[aliyahwakil]

• [ ] Janice will check with Derek about PLHIV in DATIM. Imran provided R script and output file with data previously used
• [x] Aliyah to send metrics to be added to TSD dataset that Janice has already created
• [x] Aliyah to send logic for TX_NET_NEW analysis metrics to be created for aggregate table
• [ ] Chapter 3 is on hold because of further discussions around historical data and access is needed
• [ ] Janice will continue working on creating TX_NET_NEW target

[janholcombe]

Aliyah sent the following additional requirements for the metrics to be added to the TSD dataset:

Metrics to Add to TSD dataset using Result Cumulative:

• [x] Ratio of TX_NEW and TX_NET_NEW = TX_NEW /TX_NET_NEW
• [x] Number of tests needed to find 1 PLHIV = HTS_TST/HTS_TST_POS
• [x] HTS %Yield = HTS_TST_POS/HTS_TST
• [x] Difference between TX_NET_NEW and TX_NEW = TX_NET_NEW – TX_NEW
• [x] % Gain or Loss = (tx net new - TxNew cumulative)/TxCurr current period cumulative)

*Calculation includes previous period

Example of TX_NET_NEW Analysis aggregate table:

Metric logic for TX_NET_NEW Analysis aggregate table

• [ ] TX_CURR at sites no longer reporting in current period: TX_CURR value is >0 for previous APR but 0 or missing for current period
• [ ] TX_CURR at sites newly reporting in current period: TX_CURR value is 0 or missing for previous APR but is >0 for current period
• [ ] TX_NEW at sites reporting TX_CURR in both previous APR and current period: TX_NEW for sites where TX_CURR value is >0 for previous APR and current period
• [ ] Difference between TX_NET_NEW and TX_NEW in sites reporting TX_CURR in both previous APR and current period: Difference between TX_NET_NEW and TX_NEW for sites where TX_CURR value is >0 for previous APR and current period
• [ ] Total from sites with negative values or zero for difference between TX_NET_NEW and TX_NEW: Difference between TX_NET_NEW and TX_NEW values are <0 or 0
• [ ] Total from sites with positive values for difference between TX_NET_NEW and TX_NEW: Difference between TX_NET_NEW and TX_NEW values are >0

[aliyahwakil]

thanks @janholcombe ! i updated the equation for % gain/loss