Inserting records for nth percentile projections
Similar to the previous section, you can insert records that allow nth percentile calculations. The following is a sample insertion to the projection_config table for a 95th percentile projection:
insert into projection_config (name, nth_percentile_config_id, days_past, days_future, agg_column_name) values ('austin_95th', 1, 60, 30, 'fct_percentile')
where 1 is the ID of the row in the nth_percentile_config table where the Austin 95th percentile calculation is defined.