• Archive
  • Back to www.mscrm-addons.com
  • Archive
  • Back to www.mscrm-addons.com
home/Knowledge Base/Template Designer(DCP)

Aggregation in DocumentsCorePack – an overview

84 views 0

Written by Administrator
August 16, 2016

This article outlines the basics of aggregation, a functionality of Microsoft Dynamics CRM, that we have integrated in our Template Designer.

The functionality is very useful when you want to create an overview to certain data and sum or calculate the average of revenues or sales. It can also be used to create quaterly, yearly, monthly or daily reports. Please find an example on how to use aggregation properly here.

Aggregation fetches enable you to calculate sum(s), average minimum & maximum and count items. All aggregation methods supported by Microsoft Dynamics CRM can be easily applied to any template, although the selection depends on the fields to be inserted.

The following aggregate functions are supported by Microsoft Dynamics CRM:

1) AVG
This functionality computes the average values for all entities or relationships used
for the template.
    Please note: 0 is not considered when the average is calculated. However, the result of
a calculation including 0 is replaced by zero (0).

2) COUNT (Subfunctionalities: COUNTCOLUMN, COUNT DISTINCT COLUMNS)
This functionality provides you with a count of all entities or relationship used for the
template.

3) MAX
This functionality provides you with the maximum value of a certain selection of entites.
    Please note: 0 is not considered when the maximum value is calculated. However, the
result of a calculation including 0 is replaced by zero (0).

4) MIN
This functionality provides you with the minimum value of a certain selection of entites.
    Please note: 0 is not considered when the minimum value is calculated. However, the
result of a calculation including 0 is replaced by zero (0).

5) SUM
This functionality provides you with a sum of all entities or relationships used for the
templates.

6) MULTIPLE AGGREGATES
This functionality enables you to use multiple aggregate attributes to set a minimum
and a maximum.

7) GROUP BY
This functionality enables you to use multiple aggregate attributes and a linked
group by attribute.

7 a) GROUP BY WITH LINKED ENTITY
This subfunctionality enables you to use the sum aggregate attribute to sum
linked entity values.

7 b) GROUP BY YEAR, QUARTER, MONTH, WEEK or DAY
These subfunctionalities enable you to group results by year, quarter, month, week
or day.

7 c) MULTIPLE GROUP BY
This functionality enables you to use multiple group by clauses.

8) ORDER BY
This functionality enables you to use multiple order by clauses.

Please click here to get an example on how to use aggregation fetches properly.

That’s it! We appreciate your feedback! Please share your thoughts by sending an email to support@mscrm-addons.com.

reworkneeded… more details..screenshots.. examples

Was this helpful?

Yes  No
Related Articles
  • General Settings – DocumentsCorePack Server Based
  • How to use the Insert-as-Picture-Link-Field-button in Dynamics-365
  • How to use the Insert-as-Picture-Link-Field-button in Dynamics-365
  • Documents generated in Flows cannot be opened
  • How licenses are counted
  • How to setup editable sections in your template (Dynamics 365)
Latest Articles
  • TemplateImportExport Console Application – DCPIE.exe
  • How to trigger a Microsoft Flow from dialog
  • General Settings – DocumentsCorePack Server Based
  • How to use the Insert-as-Picture-Link-Field-button in Dynamics-365
  • What is “documents incl. per month”
Popular Articles
  • How to activate the DocumentsCorePack connector for PowerApps & Microsoft Flow
  • How licenses are counted
  • Where do I find the Unique Organization name in Microsoft Dynamics 365?
  • How to work with the new DocumentsCorePack custom connector for PowerAutomate (Microsoft Flow)
  • DocumentsCorePack Charts Feature (Dynamics 365)
Top Rated Articles
  • How to activate the DocumentsCorePack connector for PowerApps & Microsoft Flow
  • Can you save data capacity by moving email content?
  • Step-by-Step: How to configure a One-Click-Action
  • How to set up an email content service
  • How to work with the new DocumentsCorePack custom connector for PowerAutomate (Microsoft Flow)
Categories
  • *News and General Infos* 43
  • Template Designer(DCP 151
  • DocumentsCorePack(DCP 146
  • TelephoneIntegration (TI 62
  • AttachmentExtractor (AE 47
  • PowerSearch (PS 43
  • ActivityTools (AT 55
  • SmartBar (SB 50
  • GroupCalendar (GC 43
Our Vision

“We see it as our purpose to provide products that simplify and speed up our customers’ Microsoft Dynamics 365 experience.”

Knowledgebase
LogIn
mscrm-addons.com
  • Products
  • Online Shop
  • Downloads
  • My Account
About Us
  • About Us
  • Case Studies
  • Newsletter
  • Partner Program
  • Contact
Support
  • Support
  • Terms & Conditions
  • Documentation
  • Webinars
  • Legal Documents
  • Impressum
  • © 2020 www.mscrm-addons.com. All Rights Reserved.