Custom Aggregations for custom DataSource API

Hello, Rodrigo,
 
Thank you for your question.
 
Custom aggregations can be added in the following way:

1. First, specify the custom aggregations in the list of all available aggregations (in the aggregations property of the /fields response). Please see the following guide for reference.

   For example: 

   // The /fields response
   
   {
      aggregations: {
         any: ["count", "distinctcount"]
         date: ["count", "distinctcount", "min", "max"]
         number: ["sum", "count", "distinctcount", "average", "min", "max", "custom1"]
      },
      fields: [...],
      filters: {...}
   }

2. Once the custom aggregation names are added to the list of all aggregations, it is possible to add them for specific fields. 
   By specifying the available aggregations for the fields, you could limit the aggregation list to contain only the needed aggregations. This way, you could specify which fields each custom aggregation should be available for.

   For example: 

   // The /fields response
   
   {
      aggregations: {
         any: ["count", "distinctcount"]
         date: ["count", "distinctcount", "min", "max"]
         number: ["sum", "count", "distinctcount", "average", "min", "max", "custom1"]
      },
   
      fields: [
        {
           aggregations: ["sum", "count", "distinctcount", "average", "min", "max", "custom1"]
           caption: "Price"
           type: "number"
           uniqueName: "Price"
        },
        {
           aggregations: ["sum", "count", "distinctcount", "average", "min", "max"]
           caption: "Quantity"
           type: "number"
           uniqueName: "Quantity"
        }
        ...
      ],
   
      filters: {...}
   }

        As a result, the "custom1" aggregation will be available for "Price" but not for "Quantity".
 
Please let us know if this helps and if everything works fine for you.
Looking forward to your response.
 
Kind regards,
Vera

Hello, Rodrigo,
 
Thank you for your response. 
 
We are happy to hear that you found our explanation helpful.
The aggregations property of the /fields response does behave as the default list inherited by all fields. However, it also acts as a definition of all aggregations that are supported on your server.
At the same time, our team understands that such an approach could not be convenient for cases when there are multiple fields.
With this in mind, we have added a task to our backlog, and our team will see how specifying custom aggregations for specific fields could be improved. We will keep you updated. 
 
Please feel free to reach out if further questions arise.
 
Kind regards,
Vera

Hello, Rodrigo,
 
We are happy to announce that our team improved the flow for adding custom aggregations.
Now it’s possible to add a custom aggregation for a specific field without having to first specify it in the "aggregations" property of the /fields response.
 
This is available in the latest version of Flexmonster.
You are welcome to update the component. Here is our updating to the latest version guide for assistance.
 
Please let us know if the update works fine for you.
We would be grateful for your feedback.
 
Kind regards,
Vera

Hello, Rodrigo,
 
Thank you for your response. 
 
About date aggregation values getting exported to Excel as dates instead of numbers:
Thank you for reporting this issue. We would like to confirm that this is not the expected behavior. Our team will look into this issue, and we will share the results with the ETA 14th of June.
As for names for custom aggregations, currently, they should be specified in lower case letters. 
 
A possible workaround is to create a calculated measure based on the field's custom aggregation and use it in the slice.
For example: 

{
  "uniqueName": "Year count",
  "formula": "numberofyears(\"date\")",
  "caption": "Year count"
}

Calculated measures are of type number, hence, in the exported Excel, the values will be displayed as numbers as well.
Such an approach will also provide more flexibility for custom aggregation names - you can specify any desired caption for calculated measures.
 
Please let us know if this would work for you and if any questions arise.
 
Kind regards,
Vera

Hello, Rodrigo,
 
We are happy to inform you that the issue with formatting date/time values in Excel for number aggregations like count was fixed.
This is available in the latest version of Flexmonster (v2.9.1).
 
You are welcome to update the component. Here is our updating to the latest version tutorial for guidance.
 
Please let us know if the fix works fine for you.
 
Kind regards,
Vera

Hello, Rodrigo,
 
Thank you for your feedback.
We are happy to hear that everything works.
 
Should further questions arise, feel free to reach out.
 
Kind regards,
Vera