Skip to main content

Dashboard Pivot Value Calculations

Written by Ellen Kajca

Values are what shows in the cells of a dashboard pivot table. Hive calculates each value for every row and column group.

Add a value

  1. In the pivot settings, under Values, click Add value.

  2. Select a value, for example Estimated time or Time Tracking Hours.

  3. Under the value, use Display by to choose how it is calculated, for example sum, average or median. The choices depend on the value.

Custom formulas

There are two ways to calculate a value from other values:

  • Custom formula: combine two values with +, −, × or ÷.

  • Value: write your own formula.

To write a formula:

  1. Click Add value and select Value.

  2. In the value box, type =, then click the pencil icon to open Edit formula.

  3. Type the formula. To add a value or a function, select it in the Fields or Functions tab.

  4. Click Save.

Formulas use formula.js syntax, which is similar to Excel. To reference a value, use field("Value name") with the name exactly as it shows in your pivot. If you renamed a value, type its new name. The Fields tab shows the original name. Each value in the formula must also be in the pivot.

Examples

Difference between tracked and estimated time:

=field("Time Tracking Hours") - field("Estimated time")

Hours over the estimate only (0 when the work is on or under the estimate):

=IF(field("Time Tracking Hours") > field("Estimated time"), field("Time Tracking Hours") - field("Estimated time"), 0)

Related Articles
Did this answer your question?