Calculated metrics content library - what are you looking for? 📚
A deep-dive technical introduction (helpful if you're looking to understand the broader data structure of Planhat, and its implications for calculated metrics)
Use cases and examples (and some more Examples)
Quite specific - the SIGN function
When creating your calculated metrics you can use the system metrics, user metrics, activity data, and custom data on company profiles.
These are all items that will be specified as the "prop": value, and here is how to ensure you're using the correct naming conventions.
**Always, when creating a calculated metric and specifying which metric/activity to use, use the EXACT spelling, spacing, and capitalization that displays.
However, when creating calculated metrics from the System Metrics, use the following:
system.users_total (for Number of users)
system.activity_count (for Activity Count)
system.users_active_last1 (for Users active last day)
system.users_active_last7
system.users_active_last30
system.users_active_last90