search

USAID-OHA-SI / WeekendSpecial

SA weekly data munging
0 stars 1 forks source link

Create Proxy Linkage Indicator #40

Closed achafetz closed 6 years ago

achafetz commented 6 years ago

LINKAGE = TX_NEW/HTS_TST_POS

achafetz commented 6 years ago

Did this in R and then realized it's probably best to do in Tableau (due to any potential aggregation?)

In Tableau, created 3 measures - TX_NEW, HTS_TST_POS, and then Linkage off of those two

//HTS_TST_POS
IF[Indicator] = "HTS_TST_POS" THEN [Result Wkly] 
ELSE NULL
END

//TX_NEW
IF[Indicator] = "TX_NEW" THEN [Result Wkly] 
ELSE NULL
END

//PROXY_LINKAGE
SUM([TX_NEW])/SUM([HTS_TST_POS])