In the previous tutorial How to create a SCORE metric we showed how you can create an effective SCORE calculation on a metric. However, there is limited value in creating a score on a single metric since we already report the status of every metric by default. The score method is best used as a factor in more advanced calculations. In this tutorial, we’ll show how you can bubble a bad status score to the top of your blocks tree, maximising the visibility of problem areas so they can be acted upon quickly.
First, we need to start with a cascading metric. In this example we have a metric called Expenses. Here’s a table where all the leaf blocks are displayed with their expenses metric in the Single Metric column: