DataPalooza 2021

ADVANCED METRIC FUNCTIONS

METRIC EDITOR - FORMULA We are also able to create our own metric. To do so simply right click in the metric section of your dataset and select Create Metric (Figure 8). This will take you to the Metric Editor window. From this window we will want to switch over to the Formula Editor, located on the bottom left of Figure 9.

Figure 9 - Metric Editor

Figure 8 - Create Metric

In Figure 9, we show some of the operations available in the Metric Editor. Feel free to explore these features but for this demonstration we will focus on building our own formula. In Figure 10, we simply add 5584 Number of Loans To Finance Agricultural Production And Other Loans To Farmers Less than $100k + 5586 Number of Loans To Finance Agricultural Production And Other Loans To Farmers More than $100k to 250k + 5588 Number of Loans To Finance Agricultural Production And Other Loans To Farmers Greater than $250k to solve for Total Number of Loans for Agricultural Production. To simplify I will refer to them by their code: . = 5584 ( >100 ) + 5586 ( 100 −250 ) + 5588 ( <250 )

8 | P a g e