Aggregated Calculation Field Type
Easily configure calculated values based on aggregated data
The Aggregated Calculation field type displays calculated summary values & KPI’s*, based on aggregated data retrieved from a local/remote list view.
Unlike out-of-the-box SharePoint calculated column that displays calculated values based on current item’s columns, the Aggregated Calculation column allows you to show summary calculated values based on many aggregated items from any other list.
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.
* Together with the KWizCom KPI field type.
Key Features & Benefits
| Feature | Aggregated Calculation Field Type |
|---|---|
| Display summary functions (Count, Sum, Avg etc.) based on remote list views | |
| Use current list column values as dynamic properties | |
| Optionally allow end-user to change the configured summary function | |
| Enable configuring cache period | |
| Enable configuring auto-refresh period | |
| Integrate with KWizCom KPI column and Conditional formatting column |
Related Products
KPI Field Type
Easily visualize your goals, progress and status!
Conditional Formatting Field Type
Easily & quickly visualize your SharePoint content using conditional formatting.
List Aggregator
Aggregate data from lists & libraries across entire farm into a single clear consolidated view!
Primary Version
| Version | 11.0.09 |
| Base Version | 11.0.07 |
| Release Date | Nov-19-2018 |
Version 11.0.09, Nov-19-2018
| 5728 | Fixed: DateTime field doesn't return value and throws exception |
Version 11.0.07, Apr-01-2018 - Base version
SharePoint 2013-2019 add-ons require the installation of
KWizCom SharePoint Foundation package.
Click here to download the latest KWizCom 2013-2019 Foundation package.
Documentation & Tools
| Description | |
|---|---|
| Description: User Guide | DOWNLOAD |
Single Server License: Aggregated Calculation Field Type
| Item | SKU | Price (USD) | Payment Type | Action |
|---|---|---|---|---|
| Item: Aggregated Calculation Field Type + Standard Support | SKU: KAFT+std | Price: $629 | Payment Type: 1-time | ORDER NOW |
| Item: Development License for Aggregated Calculation Field Type | SKU: DEV(KAFT) | Price: $157 | Payment Type: Annual | ORDER NOW |
| Item: Annual support renewal for Aggregated Calculation Field Type | SKU: STD(KAFT) | Price: $157 | Payment Type: Annual | ORDER NOW |
This add-on is licensed per-WFE server, meaning: every web front-end server requires a separate license.
* Development license, same as the annual support service, needs to be renewed every year otherwise it will expire.
For more pricing information, volume discount and educational discount, please send an email to sales@kwizcom.com
Top