View a List as a Chart

See how the records in a list break down by a field, such as fund, gift type, or prospect status, without exporting data or building a report. The chart uses the filters applied to the list and updates when you change them. Chart view is available on gift, opportunity, and constituent lists.

  1. Open a gift, opportunity, or constituent list.

  2. Select Chart view.

  3. In Group by, select the field to chart, such as Fund or Gift type on a gift list.

  4. To compare amounts instead of counting records, select an option in Aggregation, and then select an amount in Aggregation field.

  5. If you group by a date, such as Gift date, select an interval in Date interval.

  6. To change how the results appear, select Column, Bar, Line, Area, Pie, or Table in Chart type.

The chart updates each time you change a selection. A chart shows the top 25 groups, ordered from largest to smallest by the value you're charting. When a chart reaches 25 groups, a note names the number of groups shown and the value they're ranked by. If the field has more values, the chart leaves them out. For example, if a list has 50 constituent codes and you group by constituent code, the chart shows the 25 codes with the highest count.

Select What to Calculate

The aggregation you select determines what each group shows:

  • Count shows the number of records in each group.

  • Sum shows the total of the selected amount.

  • Avg shows the average of the selected amount.

  • Min and Max show the smallest and largest of the selected amount.

Gift lists offer Gift split amount, Received amount, and Committed amount. Opportunity lists offer Ask amount, Expected amount, and Funded amount. Constituent lists offer Count only.

Some fields can have more than one value for a record. For example, a constituent can have several constituent codes or schools. When you group by one of these fields, the record counts once in each of its groups, so the group counts can add up to more than the number of records in the list.

How Gift Amounts Are Calculated

On gift lists, Sum, Avg, Min, and Max calculate from gift splits, not whole gifts. Each split carries its own amount, so the chart reports on the split amounts in each group.

For example, a $7,200 gift is split $6,000 to Annual Fund and $1,200 to Scholarship Fund. When you group by Fund and select Max for Gift split amount, the chart shows $6,000 for Annual Fund and $1,200 for Scholarship Fund. It never shows $7,200 because no single split has that amount. Avg works the same way and shows the average split amount, not the average gift amount.

Note: Fields that apply to the whole gift, such as Constituent and Gift type, also calculate from splits. Max grouped by constituent shows the largest single split for each constituent, which can be smaller than their largest gift.

Count is different because it counts gifts. A gift split across two funds counts once in each fund, so the group counts can add up to more than the number of gifts in the list. A gift with several splits to the same fund counts once for that fund.

On opportunity lists, amounts calculate for each opportunity.

See the Records Behind a Group

Select a segment of the chart, or an amount in the table, to open a flyout with the records in that group. The total at the top of the flyout uses the same aggregation and amount as the chart. Because the flyout lists records, a gift split across several funds appears in the flyout for each fund it was split to.

To keep working with a group, select Open as new list in the flyout. This isn't available when the list includes filters that aren't visible.

Records with no value for the field you group by appear in their own group, labeled "(blank)", "Unknown", or "Not set" depending on the field. For example, gifts with no campaign appear in the "(blank)" group. Because the list has no filter for blank values, you can't open that group, but you can open the others.

Note: Some fields show values in the chart but don't open records because the list has no filter for them, and a message explains that drill through isn't enabled. On gift lists, Date added and Anonymous work this way. On constituent lists, Constituent type, State, City, Active status, Deceased status, and Prospect Insights Pro Queue Category work this way. On opportunity lists, Constituent works this way.

Calculate Key Info for a List

On gift and opportunity lists, select Key info in the list summary to see the average, smallest, and largest amount for the records that match the current filters. Nothing is calculated until you select it.

  • In the list, the values are for gift split amounts on gift lists, such as Average gift split amount, and for ask amounts on opportunity lists. Gift values follow the same split-level calculation as the chart.

  • In chart view, the values follow the Aggregation field you selected for the chart, so they match what you're looking at. For example, if you select Received amount on a gift list or Funded amount on an opportunity list, Key info calculates for that amount.

  • In the drill-through flyout, the values use the same amount as the chart you selected the group from and cover only the records in that group. You can compare them to the values for the whole list.

After you select Open as new list, Key info returns to the default amount for that list type. To see a different amount, switch to chart view and select it in Aggregation field.

Select Key info again after you change the filters, change the aggregation field, switch views, or refresh the list, because the previous values clear. If a calculation fails, select Try again.

Note: Key info isn't available on constituent lists or while a search is applied to the list.