DataPalooza 2021

ADVANCED METRIC FUNCTIONS

CREATING A METRIC

MEDIAN Right click and create new metric. Once in the Metric Editor screen we will create a function that takes the Median of E013. We have addition options below our function - function parameters, levels, and filters. The leveling option is the most important part to take away from this exercise. Note: Any metric in the Dataset can be right clicked and you are able to edit the Number format to change decimals if need be.

Part 1 – Bank State Making our first level equal to Bank State this would take the median of E013 by each state. Each state would have a unique median, but our visualization would show the same median for State Chartered and Not State Chartered banks. To avoid this issue let’s add a second level. Part 2 – Bank State Chartered For our second level we add Bank State Chartered. Our return will now have a unique median for State by State Chartered vs Not State Chartered.

Figure 13 – Level Metric

11 | P a g e