Skus
column might contain multiple products, tiers, and quantities in one text string, making direct calculations difficult.
The Context feature resolves this by allowing users to define parsing logic with a JSON input. Without this logic, the system cannot perform calculations on data embedded within text.
The following code snippet shows an example of using JSON context ~~was provided ~~to teach the system how to parse the Skus
column:
Skus
field for every contract in real-time. It filters for the “Sales” product, identifies the “Ultimate” tier, extracts the corresponding quantity, and aggregates the total, providing a precise numerical answer that was previously impossible to calculate.