Calculated Fields
*****************
Please add these four Calculated Fields in your Tableau workbook.

1. Prediction Loan Risk 
// Logic to label Bad Loans from DataRobot Predictions for use in Tableau dashboards
IF([Prediction] > 0.10) THEN "TRUE" ELSE "FALSE" END


2. Prediction Loan Risk Category
// Logic to add Loan Risk Category labels from DataRobot Predictions for use in Tableau dashboards 
IF ([Prediction] > 0.0 AND [Prediction] < .10) THEN '1 LOW RISK' 
ELSEIF ([Prediction] >= 0.10 AND [Prediction] < .20) THEN '2 MEDIUM RISK' 
ELSEIF ([Prediction] >= 0.20 AND [Prediction] < .30) THEN '3 HIGH RISK'
ELSE '4 VERY HIGH RISK ' 
END

3. Prediction Explanation
// Combining Top 2 DataRobot Prediction Explanations for use in Tableau Tooltips
UPPER([Explanation 1 Feature])  + ' : ' + [Explanation 1 Value] + '  ' + UPPER([Explanation 2 Feature])  + ' : ' + [Explanation 2 Value]

4. % Probability of Default
// Renaming DataRobot Prediction field for Tableau dashboard slider
[Prediction]