asked on April 27, 2017
Currently I am giving the data to the pivot which is already aggregated (in JSON format), so now when I am clicking on the drill through, I want to first make a server call to get the detailed data (which can be done by having my method inside celldoubleclick event) but then can I supply this new data for the drill through ?
I know you would say that instead of initializing the pivot with aggregated data, try to send the detailed data itself, but lets say we cant do that right now.
⋅ April 27, 2017
Hi Sohan,
I understand your problem but unfortunately, there is no quick solution. We already discussed this issue and there is no better way that we already recommended to you.
Regards,
Roman
⋅ April 27, 2017
Thanks Roman, But what was the recommended way in this case, can you please explain it again ?
⋅ April 27, 2017
Sohan,
Here is the required demo http://jsfiddle.net/flexmonster/dbaw72fw/
Please right click on the grid to see Open in New Pivot.
Does it help?
Regards,
Roman
⋅ April 27, 2017
Oh yes, I am aware of this one, which is still our one of the requirements. But now we have a scenario where we want to provide the data to the flat table which comes up as a result of drill through.
Can you confirm there is no way to achieve this right now ?
⋅ April 27, 2017
Sohan,
There is no way to provide data to drill through table but you can use this sample to achieve your goal. I understand it's not the same but you can add a new table in flat mode and fill it with your data.
⋅ April 27, 2017
in this way, can we show new table instead of pivot ?
⋅ April 27, 2017
Can we have a call Roman, if possible ?
⋅ April 27, 2017
Yes, you can show new table over the pivot (http://jsfiddle.net/dbaw72fw/20/) or hide it at all (http://jsfiddle.net/dbaw72fw/17/)
We can arrange the call for tomorrow.
⋅ April 27, 2017
Thanks Roman, I am good for now. That helped
⋅ May 5, 2017
Hi Roman,
For the new table over the pivot (http://jsfiddle.net/dbaw72fw/20/), I am not getting the close button on the right top which is there when you drill through.
Also I would like to show the details of cell selected from parent pivot onto this new pivot, just like the existing drill through popup.
How can I get it ?
⋅ May 8, 2017
Hi Roman, Gentle reminder !
⋅ May 8, 2017
Hello Sohan,
Thank you for the details.
Actually, you can change the view of the popup using JS/HTML/CSS.
For instance, please take a look at the following sample - https://jsfiddle.net/flexmonster/1rm53nt9/
I have added a jQuery popup with a close button to show the new pivot.
Also, added the details of the cell selected from parent pivot.
Since this is a demo and it is built on top of the Flexmonster API, you can use the API and change any of this code to suit your needs.
Hope it helps.
Regards,
Ian
⋅ May 8, 2017
Thanks Ian
⋅ July 2, 2019
Hello, I would like know if today (2019) can I supply the data for drill through instead of default data available.
when clicking on the line I would like to recover the data and make a new query to the server and then it would return a json with the detailed data of that object.
⋅ July 3, 2019
Hello, Bruno,
Thank you for your question.
We would like to confirm that it is possible by showing a new table over the pivot.
Please consider this workaround that is explained in this thread.
Let us know if you have further questions.
Best Regards,
Vera
