Enhanced report

We made updates to ensure acceptable performance for the Milestone Prediction Dashboard report.

Milestone Prediction Dashboard

With release 23.3, the following fields exist but now have NULL values in the milestone_predictions view:

• number_of_countries
• sites_in_study
• sites_in_country
• start_month
• pi_counts
• therapeutic_area
• phase

The above change in the milestone_predictions view means that the following columns are now blank in the Milestone predictions and Prediction analysis worksheets:

• No. of Countries
• No. of Sites in Study
• No. of Sites in Country
• Study Attributes

We also deprecated these unused feature importance fields since they are no longer applicable to current prediction models:

milestone_predictions

• importance_rank_0_score
• importance_rank_0_feature
• importance_rank_1_score
• importance_rank_1_feature
• importance_rank_2_score
• importance_rank_2_feature
• importance_rank_3_score
• importance_rank_3_feature
• importance_rank_4_score
• importance_rank_4_feature