DataPalooza 2021

ADVANCED METRIC FUNCTIONS

Figure 18 – Largest Differences from Median

LAG METRIC FUNCTION Create a new chapter.

This section will focus on the lag metric function. The Lag function is useful to display a set of metric values in an order determined by another metric or attribute on the report. For our example we will use the lag function to find total assets last year and compare them to the current total assets.

BUILDING A VISUALIZATION

EDITOR Start by pausing your data retrieval. Once paused let’s start by dragging over Bank Cert, Bank Name, Bank State and Bank State Chartered Attributes into the Rows. Next, let’s add Total Assets to the Metrics section of our Visualization. Then resume your data retrieval and visualization 1 will populate. Please refer to Figure 19 if you need assistance.

14 | P a g e