This content is also available at learn.palantir.com ↗ and is presented here for accessibility purposes.
Deriving values with a numeric formula requires that inputs be numeric values. The steps in the previous task generated those values, which you’ll now use in a numeric formula to achieve your derived calculation
Near the center of your analysis toolbar at the top of your screen, click the Numeric menu and choose Numeric formula (you may need to collapse your configuration panel on the right of your screen to show the Numeric button).
Each card in your analysis has a variable name associated with it for easy reference in calculations. Take a moment to look in the top left corner of each of your cards and locate the variable name, known as a Plot Reference in Quiver, and which take the form of $J.
Find the plot reference values for the two numeric metrics you just derived: Route Flight Count and Route Delay Count.
In the Numeric Formula card editor, type the Plot Reference for Route Delay Count, then a / to indicate a divide operation, and finally the Plot Reference for Route Flight Count. For example: $O/$S.
Click the Update button at the bottom of the formula area. As you can see from the result, you’ll need to apply some formatting.
Click the Display tab in the Numeric Formula configuration panel.
In the Format section at the top, click the “gear” icon and change the format to Visual format.
In the format editor that opens, change the Base type to Percentage.
Apply these additional settings:
To ensure your metric is recognizable in the Analysis Contents list, click into the generic name at the top of the editor (i.e., Numeric Formula) and change it to Flights Delayed on Route.
Save your analysis.