call 905-370-0333
Live chat

Aggregated Calculation Field Type

Overview

Easily configure calculated values based on aggregated data

The SharePoint Aggregated Calculation field type display calculated summary values and KPI’s*,

based on aggregated data retrieved from a local/remote list view.

 

Aggregate values from remote list views

Unlike out-of-the-box SharePoint calculated column which can display calculated values based on the current item’s columns, the Aggregated Calculation column enables you to display summary calculated values based on many aggregated items from any other list.

* Together with the KWizCom KPI field type.

The Business Need

Dashboard sites such as Enterprise Project Management (EPM) portals for example, often need to display summary figures and kpi's which are based on aggregated data from multiple sub-sites (project sites in the EPM portal example).

With the Aggregated Calculation field you can easily configure and display summary columns for each sub-site. The following example displays various summary values and kpi's for each project site:

Aggregated kpi's from multiple project sites

 

Key Features & Benefits

Main key features of Aggregated Calculation Field Type are:

Feature Aggregated Calculation Field Type
Display summary functions (Count, Sum, Avg etc.) based on remote list views.

Yes

Use current list column values as dynamic properties.

Yes

Optionally allow end-user to change the configured summary function.

Yes

Enable configuring cache priod.

Yes

Enable configuring auto-refresh period.

Yes

Integrate with KWizCom KPI column and Conditional formatting column.

Yes

  Order Now

Aggregated Calculation Field Type

KWizCom MVP Licenses