DataPalooza 2021

ADVANCED METRIC FUNCTIONS

CASE FUNCTION Create a new chapter.

This section will focus on the case function. Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. The case function is written out, ( 1, 1, 2, 2, … , ) We will specify a list of conditions and corresponding return values. Our goal here is to break up count of banks based on asset levels. Once that is done, we will add a few quarters to see the change over time.

BUILDING A VISUALIZATION

EDITOR Simply add Bank State and Count of Banks to the visualization.

FILTER For this exercise we will use the filter panel to display only 2019Q1. Later, we will add all of 2019 to see the change over time.

CREATING AN ATTRIBUTE

CASE FUNCTION

18 | P a g e