DataPalooza 2021

ADVANCED METRIC FUNCTIONS

Right click in the attribute area of your dataset and create a new attribute. We will construct a case. A case function operates like an IF ELSE statement. The Case function returns a value based on which conditional expression is TRUE. It evaluates multiple expressions and returns a specified value when a condition pass. If no condition passes, a default value is returned. In the figure below, we add cases for different Total Assets levels. In the DESC section we replace our case ID with actual text. In the ID section please type the following: Case(([Total Assets]<=100000), 1, (([Total Assets]>100000) And ([Total Assets]<=500000)), 2, 3) If total assets are under 100,000 then the function will return case 1. If greater than 100,000 and less than 500,000 the function returns case 2. If total assets doesn’t fall under those two it must be larger than 500,000 and the function would return case 3.

In the DESC section please type the following: Case(([Total Assets]<=100000), “Under 100M”, (([Total Assets]>100000) And ([Total Assets]<=500000)), “101M to 500M”, “Over 500M”) This function follows the same logic as the one above the only difference is that rather than an output of 1, 2, or 3 we will get actual text.

19 | P a g e