Enhance your dashboard insights with custom calculations in Hive.
This guide walks you through creating advanced formulas to tailor data analysis exactly to your needs.
What Are Custom Calculations
Custom calculations are advanced formulas that perform mathematical operations or data transformations based on existing values or predefined logic. They are ideal for developing business-specific KPIs, ratios, and conditional metrics.
Types of Custom Calculations
Argument-Based Formulas
These are straightforward calculations using basic arithmetic between two existing values.
Operations available:
Plus (+)
Minus (-)
Multiply (×)
Divide (÷)
To use argument based formula:
1. Click "Add value" and select "Formula".
2. Provide the title of the column.
3. Choose the operation (+, -, ×, ÷, or Define).
4. Select two existing values or columns as arguments.
5. Set the display format: number, percentage, currency, etc.
Code-Based Formulas
These allow powerful calculations using Excel-like functions such as SUM(), AVERAGE(), IF(), and more.
Using formulas, you can reference multiple columns, set up conditional logic, and more. Make sure to check out our supported fields using this link.
To use the code-based formula:
Add Formula Value: Click "Add value" and select "Value"
Name Your Formula: Enter a descriptive name for your calculation
Start with =: Begin your formula with = to trigger code-based formula mode
Write Your Formula: Use Excel-like syntax with functions like SUM(), AVERAGE(), IF(), etc.
Use Formula Editor: Click to open the modal editor for complex formulas
Set Display Format: Choose your output format using "Display as" options
Get AI Help: Use Buzz to assist with formula building by sharing supported fields and your calculation goals
=IF(field("Time Tracking Hours")>field("Estimated time"),"Over","Under")
In the example above, the custom field checks the values of the Time Tracking Hours column and the Estimated Time column. If the Time Tracking Hours value is greater than the Estimated Time value, it shows "Over." Conversely, if the Estimated Time is greater, it shows "Under."