How to expand specific element using API to dill down from google chart

posted on January 20th, 2017

Closed

Bhagvan Chougule asked on January 20, 2017

We are integrating google charts with pivot table. We want to build functionality to drill down from google charts. The approach we are using is when user clicks on element in google chart we will call flexmonster API to expand the specific member and refresh google chart.
when specific member is expanded following is what gets added to config json.
expands: {
rows: [{"tuple": ["country.[Canada]"]}]
We want to mimic this by calling API. expandData opens all the elements of specific category.

6 answers

Public

Roman Petrusha ⋅ Flexmonster ⋅ January 20, 2017

Hi Bhagvan,
Thank you for the question.
Unfortunately, there is no required method in the JavaScript API. We will keep in mind your request in the future development planning.
Thanks,
Roman

Public

Bhagvan Chougule ⋅ January 20, 2017

Has anyone achieved drill down from third party visualization library? And what could be the approach/solution to achieve that?

Public

Dmytro Zvazhii ⋅ Flexmonster ⋅ January 23, 2017

Hello Bhagvan,
Our developer's team need to take some time on analysing this use case and founding an appropriate solution.
We will notify you about the results.
Best regards,
Dmytro.

Public

Iryna Kulchytska ⋅ Flexmonster ⋅ February 27, 2017

Hello Bhagvan,

We have prepared a sample for you that illustrates the possible approach to building the functionality to drill down from google charts: https://jsfiddle.net/flexmonster/uxjm2894/

The function selectHandler() in the sample shows how expand/collapse can be toggled from the chart. As was written previously, there is no the required method in the JavaScript API of our component to trigger expand/collapse of the specific member. But we have used getReport() and setReport() API calls to get a report, modify it and set it back.

Please let us know if the above approach can work for you.

Also, please note that the flexmonster.googlecharts.js file was updated in the 2.310 minor version. You are welcome to download the latest version from the website.

Kind regards,
Iryna

Public

Tanya Gryshko ⋅ Flexmonster ⋅ March 29, 2017

Hello Bhagvan,
We were wondering whether you have had a chance to look at the sample we offered for building the functionality to drill down from Google Charts. We would be grateful for any feedback you would share with us.
Regards,
Tanya

Public

Bhagvan Chougule ⋅ March 29, 2017

this solved our problem. thanks!

This question is now closed