DataPalooza 2021

ADVANCED METRIC FUNCTIONS

Figure 22 – Lag Shows Last Q Total Assets

DIFFERENCE An easy way to calculate the difference is to right click on our visualization column. About halfway down there is an option for Calculations. We will want to do Total Assets – Total Assets Last Year, the metric created last step. This will show us if there were any gains/losses from last year.

Figure 23 – Difference Formula Shortcut

17 | P a g e