Calculated Fields

Calculated Fields

Last Updated: March 21, 2023

Intro

Endgame is capable of various ‘last mile transformation’ to help make best use of the data you’re collecting. Your Endgame rep can help build these fields for you. A few examples below.

Time-bound fields

For any event-based field (e.g. number of button clicks), you can time-bound by X number of days.

Examples: • Button clicks within last 1 day • Button clicks within the day 7 days

Math fields

You can addition, subtraction, multiplication, and division to calculate values.

Examples: • Successful Uploads / Successful Uploads + Failed Uploaded • Button clicks within last 7 days / Active users in last 7 days

Conditionals

You can use evaluation logic to determine what value to render.

Examples: • If tier like ‘pro%’, render “Pro”, else ‘org%’ render “Org”, else “Other” • If revenue > 100000 or employees > 100 render “true” else “false”

Historic values

You can look back at prior values of any field, including property fields (e.g. Subscription Status, Number of Employees).

Examples: • Seat count / Seat count 7 days ago • If subscription was active 7 days ago but isn’t now, render “true”

Contact your Endgame rep to get started with calculated fields!