| data_source | aggregator_code | weights_source |
|---|---|---|
| para_rut | perc_weight_sum_gt_12.5 | file_length |
| para_rut | mean_value | none |
| para_rut | 80th_percentile | none |
| para_naasra | mean_value | none |
| para_naasra | 80th_percentile | none |
| para_pdi | mean_value | none |
| para_pdi | 80th_percentile | none |
| para_sdi | mean_value | none |
| para_sdi | 80th_percentile | none |
| para_mesh_cracks_pct | mean_value | none |
| para_mesh_cracks_pct | 80th_percentile | none |
| para_surf_remain_life | mean_value | none |
| para_surf_remain_life | perc_weight_sum_lt_0 | file_length |
| para_pdi | perc_weight_sum_gt_10 | file_length |
KPI Set Definitions
Overview
When performing post-processing on model outputs, an often-repeated task is reviewing Key Performance Indicators (KPIs) calculated from forecasted condition parameters. For example, a KPI may be ‘the percentage of the network (by length) that has rut depth above 15mm’. You can have several more of these KPIs that you are interested in.
Cassandra has a built-in post-processing feature to look at the statistics of a selected model parameter over time. However, this tool requires you to select each parameter that form part of your KPIs one-by-one and then extract and plot the required statistic - a rather cumbersome process.
By pre-defining a KPI Set you can specify which model parameters, and which associated statistics, you are interested in. You can then use the built-in KPI Forecast feature under the Post-Processing menu to quickly view the KPIs over time for the entire set in one operation.
To use this feature, you need to first identify one or more KPI sets. You do this by editing the template file ‘kpi_setups.xlsx’ in Excel. The template is quite easy to understand.
You can download an example template for specifying your KPI setups by clicking the button below.
Within the template file, you can specify one or more KPI sets on sheets prefixed with ‘kpi_set_’. Typically, you will only have one such KPI definition, say on sheet ‘kpi_set_main’. However, if you need more than one KPI set, you can for example use ‘kpi_set_safety’ and ‘kpi_set_pavement’. At run time, you will be asked which of these KPI sets you want to create a report for.
Note
If you download the example template using the above button, you will see that there is a ‘documentation’ sheet to show you which statistics you can use in a KPI definition set. You can also use other sheets within the workbook for notes etc. However, ensure that any sheets starting with ‘kpi_set_’ adhere strictly to the template format as explained below.
Template Format
The table below shows an example of a KPI definition set. See the documentation sheet in the template example for an explanation of which statistics are available, and how to specify more complex KPIs such as those depending on a threshold (e.g. % of length with Rut over Xmm).
Important
The table shown above must have left-upper corner in cell A1 of the sheet. You can use the cells below or to the right of the table but it is recommended that you rather make use of a seperate sheet to keep any notes etc.
Keep column names unchanged (case-sensitive) and do not change the order of columns.