🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Custom Aggregations

Re-Open
Patrick Berens asked on June 6, 2020

Hi Support,
I’m trying to use the new Custom Datasource API, however, I’m still finding limitations that are making my project difficult to achieve. Specifically, it doesn’t support custom aggregations so I can’t utilize all the features of my datasources and APIs. Right now I’m working on Percentiles, but later I’ll likely need more aggregations.

  1. Is this on the roadmap soon? It seems like for Custom Datasource API it would just be passing a string around representing a custom aggregation name then backend would need to implement it correctly.
  2. If this isn’t on the roadmap, can you recommend a way to do this? I’ve thought about possibly doing it on the backend and passing it back as a field, but when I hack it I can’t seem to display summary information I want.

Here is what i want things to look like in one of my simple pivot tables:

Rows:
– Domain

Column:
– Date (year/month/day)

Values: min, p50, p99, max

Then I would obviously like to graph this, so I can see percentile changes over time. I also sometimes will want to have “domain” and then “subdomain” both in rows as a second pivot table. 
Thanks,
Patrick

5 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster June 9, 2020

Hello, Patrick,
 
Thank you for reaching out to us.
 

  1. Our team would like to kindly inform you that the possibility to define the custom hierarchy is going to be added with a major update version 2.9. We will notify you as soon as the feature is released.
  2. As for now, we recommend considering using the following workaround.

    Add the custom server-side logic that would scan the uniqueName property of each received measure. In case the uniqueName matches the measure that needs to be aggregated in the custom way, apply the desired aggregation.

    Also, we recommend modifying the response on the /fields request in the way the measure mentioned earlier does not have any available aggregations ("aggregations": ["none"]). It is required in order to restrict the user to change the aggregation through UI (the chosen option will be ignored anyway). Please note that such a workaround limits the number of possible aggregations to the one specified on the server.

    Detailed information about the /fields request and the structure of the response on such request can be found in our documentation.

 
Our team hopes it works for your case.
Please let us know in case you have any additional questions on this point.
 
Regards,
Illia

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 28, 2021

Hello, Patrick,
 
We are pleased to inform you that added support of custom aggregations implemented on the server side.
 
This is available in the 2.8.25 version of Flexmonster: https://www.flexmonster.com/release-notes/.
 
You are welcome to update the component.
Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
 
You can find more information about the feature itself in our documentation.
 
Please let us know if it works for you.
 
Best Regards,
Illia

Public
Sengupta February 1, 2021

Hi Illia 
I am definitely passing “aggregations”: [“none”] in /fields API
e.g.

{
“uniqueName”: “Fund Mod Dur”,
“type”: “number”,
“caption”: “Fund Mod Dur”,
“dimensionCaption”: “Calc Values”,
“dimensionUniqueName”: “CALC_VALUES”,
“aggregations”: [
“none”
]
},

But the UI adding the Aggregation list
see attachment

Attachments:
agg.png

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster February 2, 2021

Hello,
 
Thank you for your question.
 
We want to explain that the displayed aggregations are implemented on the client-side. Therefore, it is not possible to disable them from your backend.
To disable these aggregations, use the aggregations property of the Mapping Object. Fill the aggregations array with only the required aggregations.
 
Please let us know if it helps.
Our team is looking forward to hearing from you.
 
Kind regards,
Illia

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster February 15, 2021

Hello, Patrick,
 
Our team is wondering whether the recently introduced feature works for you.
 
We are looking forward to your feedback.

Regards,
Illia

Please login or Register to Submit Answer