DataPalooza 2021

ADVANCED METRIC FUNCTIONS

Once done select a state. For this example, we used Alabama.

CREATING A DERIVED METRIC

PERCENT TO TOTAL Our Visualization panel now has the Quarter, Bank State Chartered, Count of Banks, and Total Assets.

Our next step will be creating our own user defined metrics – Percent to Total – which will show the percentages of State Chartered vs Not State Chartered Banks in our selected State. To do this, right click on the Count of Banks column header and navigate to Shortcut Metric >> Percent to Total >> Automatic.

Figure 7 - Shortcut Metric >> Percent to Total >> Automatic

Our new metric will be added to our visualization.

Let’s re-do the same steps but for Total Assets. Right Click Total Assets >> Shortcut Metric >> Percent to Total >> Automatic.

7 | P a g e