Our team has been using flexmonster for awhile and it does a great job thank you for that.
We are using google chart with flexmonster pivot tables. One thing we are having trouble with is, on drill down chart seem to repeat data causing wrong aggregates. This is a very important thing for us.
I have raised similar ticket a while back https://www.flexmonster.com/question/google-chart-date-drill-down-repeating-same-bars/. Want to make sure are there any developments or is it still the same case?
Could you please let us know?
Thank you for writing to us.
Our team suggests two possible solutions:
prepareDataFunctionmethod to handle multi-level hierarchies in Google Charts:
Our team has created open-source connectors for several charting libraries that process the data for you in the correct format for a head start.
In addition, you can override the data processing logic with your own by providing your
prepareDataFunction method (see Google Charts connector details).
We have an example showing an idea of how you can create a drillable column chart with Google Charts: https://jsfiddle.net/flexmonster/7yo5Lmn9/.
However, the example doesn’t cover the case when multi-level hierarchies are drilled (for example, “year/quarter/month/day” date types). This seems to be the case in your
prepareDataFunction as well.
A possible solution would be to adjust your
prepareDataFunction, so it returns only those rows that contain values of the lowest level of the hierarchy. This way, you can filter out the previous values on drill down so Google Charts won’t display them.
We hope this helps.