Open

• • 1.1 Calculate Options
• 2 Custom Calculations
• 3 Additional Calculations
  • 3.1 Chart Types With Additional Calculations Allowed
  • 3.2 Multiple Calculations on 1D Bar Charts

Open

Any Number or Date field will be selectable on the field list

Open

The calculated value is shown as a column in the legend table, the y-axis label on bar charts, and the calculated %

For calculations involving time logs, the default time unit is hours and can be changed to days, weeks, months, or years

Open

Calculations can also be made that compare multiple date fields

Open

Under common fields, you'll find the following options for date comparisons

Time Since	Calculate the time since a specific date based on the selected date field
Time Until	Calculate the time until a specific date based on the selected date field
Time Between	Calculate the time between two date fields
Time to Resolution	Calculate the time between creation and resolution. This calculation uses the Resolved date (the date a resolution is set on the issue). Open Check 'Include unresolved issues' – if you choose to include these issues, their time to resolution will be between creation and the current time.

In Custom Charts, users can measure any number field with a custom calculation or custom progress.

Open

Custom Calculation	In the 3 dropdowns, select a Jira number field, choose to add, subtract, divide, or multiply, then select the 2nd Jira number field you want to measure (options are below).   Open	Open Example: Subtract the Remaining Estimate from the Original estimate
Custom Progress	In the 1st dropdown, select a Jira number field, then in the 2nd dropdown, select another Jira number field to see the progress of the 2nd field out of the 1st field	Open Example: Time Spent of Original estimate. The chart shows % progress for each segment

Open

For certain Custom Charts chart types, users can add additional calculations after the primary Calculation is selected (the two Calculate dropdowns at the top of the gadget or macro are set).

The additional calculations can be found in: the Legend tab for pie charts and funnel charts; the Calculations (+) tab for 1D bar charts; or the Columns tab for 1D table charts.

To add an additional calculation:

1. Click the Legend, Calculations, or Columns tab (depends on chart type)

2. Scroll down to the Legend Columns section, and click +Add column

3. In the 3 dropdowns, choose how you’d like to measure the field (COUNT, SUM, or AVERAGE), choose the number or date field you’d like to measure and display, then choose to hide or show the percentage field (eyeball icon)

4. Repeat steps 2 and 3 if you’d like to add even more calculations

If you add additional calculations on the Calculations (+) tab in 1D Bar Charts, each additional calculation is displayed as a new bar on the chart (see below).

Open