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

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

Calculations can also be made that compare multiple date fields

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

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

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).