For clearer insights and consistency, you can use calculated fields to create new fields by applying functions and logic to existing data.
In Honeycomb, saved calculated fields can apply to either a specific dataset or an entire environment. Environment-wide calculated fields let you define reusable computations that apply across multiple datasets and services.
By managing these fields at the environment level, you ensure consistency in data transformation and reduce the need for redundant field definitions.
Define a calculated field to transform or derive new insights from your data.
To create an environment-wide calculated field:
Log in to the Honeycomb UI.
In the navigation menu, select the Environment label, then choose Manage Environments.
Locate the environment to which you want to add a calculated field, and select its name to open its settings.
Go to the Schema view.
Select Add New Calculated Field.
In the modal, enter details:
| Field | Description |
|---|---|
| Display Name | Name that appears in the Query Builder. Enter a name that is unique across all datasets and the containing environment. Although Honeycomb tries to prevent duplicate field names, they can still occur. For help resolving naming conflicts, visit Common Issues with Queries: Calculated Fields. |
| Editor | Formula that defines your field. For syntax, available functions, and example formulas, visit Calculated Field Formula Reference. |
Select Save.
The screen refreshes, and your new field appears in the list.
Update a calculated field to refine its formula or adjust its name.
To edit an environment-wide calculated field:
Log in to the Honeycomb UI.
In the navigation menu, select the Environment label, then select Manage Environments.
Find the environment containing the calculated field you want to change, and select its name to open its settings.
Go to the Schema view.
Locate the calculated field in the list, and select Edit.
If dependencies exist, Honeycomb will prompt you to either clone the field or continue editing. If you are unsure, contact the field’s most recent editor before proceeding.
In the modal, modify the pre-populated name and formula as needed. For syntax, available functions, and example formulas, visit Calculated Field Formula Reference.
Select Save.
The screen refreshes, and the edited field updates in the list.
If you need a new calculated field similar to an existing one, you can clone the existing calculated field and modify it as needed.
To clone an environment-wide calculated field:
Log in to the Honeycomb UI.
In the navigation menu, select the Environment label, then select Manage Environments.
Find the environment containing the calculated field you want to clone, and select its name to open its settings.
Go to the Schema view.
Locate the calculated field in the list, and select Clone.
In the modal, modify the pre-populated name and formula as needed. For syntax, available functions, and example formulas, visit Calculated Field Formula Reference.
Select Save.
The screen refreshes, and your new field appears in the list.
To manage your data effectively, you may need to delete calculated fields that you no longer need.
To delete an environment-wide calculated field:
Log in to the Honeycomb UI.
In the navigation menu, select the Environment label, then choose Manage Environments.
Find the environment containing the calculated field you want to delete, and select its name to open its settings.
Go to the Schema view.
Locate the calculated field in the list, and select Delete.
If dependencies exist, a list will appear.
To continue, remove all dependencies. If you are unsure, contact the most recent editor of each dependency before proceeding.
Select Refresh Dependencies.
In the confirmation modal, select Delete.
The screen refreshes, and the field no longer appears in the list. Existing queries using the calculated field will still work, but the field name will no longer be available when building new queries.
