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

The Slice returned from getReport does not include all available aggregations.

Christopher Phillips asked on October 2, 2018

Hello while using the getReport API I noticed that the object that gets returned for slice.measures does not include all the available aggregations for all applied measures.
I’ve attached a screenshot of the console log from a JsFiddle to show the bug. I’ve compared this to the getMeasures which does give all available aggregations but since this API getReport sometimes gives available aggregation I would expect them to always be returned.
Here is the JsFiddle: http://jsfiddle.net/chrisPhillipsWk/ak6tv47c/
In this example if you add another measure that is like Country it will show the available aggregations in the getReport call. But Price only includes the aggregation type and none of the available aggregations.

1 answer

Tanya Gryshko Tanya Gryshko Flexmonster October 4, 2018

Hello, Christopher,
Thank you for writing to us!
getReport API call returns available aggregations only for cases when not all aggregations are available. For string hierarchies selected for values, only count and distinct count aggregations are available, so they are returned for getReport. For numeric hierarchies, when all aggregations are available, they are not returned. This helps to keep the Report Object more readable and less redundant. Other API calls are specifically created to provide additional information. If you need more complete information, we recommend using these other API calls, such as getMeasure .
Please let me know if you have any other questions.

Please login or Register to Submit Answer