Table View Calculations in Quire Permalink

In Quire, you can perform calculations at the bottom of your Table view to quickly summarize the data in each column.

Calculate Column Totals

1. Scroll to the bottom row of your Table view.
2. Hover over the row to reveal the Calculate option under each column.

3. Click Calculate to perform the calculation for that column.

   

Tip: When you group your tasks by different options, you can find the calculate option at the bottom of each group. The changes made to the individual group are applied to the entire column.

Available Calculation Types

The options in the Calculate menu depend on the column’s field type.

For number fields:

• Sum – adds all values in the column
• Average – averages all values in the column
• Min – shows the lowest value
• Max – shows the highest value
• Empty – counts how many cells are empty
• Filled – counts how many cells have a value
• % Empty – percentage of cells that are empty
• % Filled – percentage of cells that have a value

For date fields:

• Earliest – shows the earliest date in the column
• Latest – shows the latest date in the column
• Range – shows the span between the earliest and latest date
• Empty, Filled, % Empty, % Filled – same as number fields

Select None to remove the calculation from that column.

New to Table view, or need to edit field values instead of calculating them? See Quire Table View or Edit Field Values in Quire Table View.

Frequently Asked Questions

How do I calculate column totals in Quire Table View?

Scroll to the bottom row of Table View, hover over it to reveal the Calculate option under each column, then click it.

Can I calculate totals per group in Quire Table View?

Yes. When tasks are grouped, a Calculate option appears at the bottom of each group. Group calculations are reflected in the overall column total.

What calculation types are available in Quire Table View?

It depends on the column’s field type. Number fields offer Sum, Average, Min, Max, Empty, Filled, % Empty, and % Filled. Date fields offer Earliest, Latest, Range, Empty, Filled, % Empty, and % Filled. Select None to remove a calculation from a column.