DataPalooza 2021
ADVANCED METRIC FUNCTIONS
Figure 14 – Median Solution Chart
DIFFERENCE Now we will create a new derived metric called E013 Median Diff. In the formula bar simply solve E013 – Median E013 . The reason we are doing this is to see if any bank stands out from their competitors on a State and Bank Chartered Level.
Figure 15 – Difference Formula
12 | P a g e
Made with FlippingBook Digital Publishing Software