Drill-through with external url call

Resolved
David Frankson asked on February 14, 2018

In the old Flash-based component we used the onCellDoubleClick() js api call to send row and column information to an external url as a drill-through function.  The new HTML component has much more drill-through functionality built-in but are their api methods or an example that shows how to extend the built-in drill-through with external calls?  Is there an api call that will add an option to the cell right-click popup menu?

13 answers

Public
Tanya Gryshko Tanya Gryshko Flexmonster February 15, 2018

Hi David!
Yes, the new component is much more flexible.  
You can easily add a new option to the cell right-click please see the working sample here: 
https://jsfiddle.net/flexmonster/1rm53nt9/
Also, I recommend you to look at these demos:
https://jsfiddle.net/flexmonster/9feqzm1m/
https://jsfiddle.net/flexmonster/dbaw72fw/
The full list of available examples you can find here:
https://www.flexmonster.com/examples/
Does it help?
Regards,
  Tanya

Public
David Frankson February 19, 2018

Is there a reason why drill-through does not work from a cell with a custom formula?

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster February 20, 2018

Hello David,
Thank you for writing. For now, the component does not support the drill through for the calculated values cells. 
Please let us know if this feature is critical for you.
Kind regards,
Dmytro

Public
David Frankson February 21, 2018

The row, column and filter values would be the same for a custom formula cell vs a regular cell so I'm not understanding why drill-through is enabled on some cells but not others.    It is tough UX to work around as any pre-made reports would always have to have a simple measure added to it and then we would need to tell end-users which cells support drill-through.

Public
Tanya Gryshko Tanya Gryshko Flexmonster February 22, 2018

Hi David!

I understand your confusion but things under the hood are a little bit more complicated and not so easy to implement.
If this feature is really critical we can add it to one of our future minor builds. Just let me know if you really need it.

Thanks,
  Tanya

Public
David Frankson February 22, 2018

I'm finding it difficult to work around it so I would appreciate it if you could add this as a feature.  Thanks!

Public
Tanya Gryshko Tanya Gryshko Flexmonster February 22, 2018

OK. I've added this feature to our development plan. It will be available in the build 4.417 (ETA 26th of March)

Thanks,
  Tanya

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster March 27, 2018

Hello David, 
We are glad to inform you that drill through for calculated values is available in the version 2.417 which has already been released. You are welcome to update the component from our website.
Kind regards,
Dmytro.

Public
David Frankson March 27, 2018

Thank you very much

Public
David Frankson April 2, 2018

I am unable to verify that this works.  None of the jsfiddle examples in the Calculated Measures section on your site seem to work.  Example:
https://jsfiddle.net/flexmonster/x0pe8azg/
If I right click on the non-formula cell I can see the drill-through popup.  If I right click on the formula cell I see nothing.

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster April 2, 2018

Hello David,
Thank you for writing. It seems that this part is not working as expected. We will add the necessary fix in the version 2.419 ETA Apr 23. 
Regards,
Dmytro

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster April 23, 2018

Hello David,
Please note that the version with the fix has already been released. You are welcome to try it.
Please let us know if the issue is resolved.
Regards,
Dmytro

Public
David Frankson April 24, 2018

Works for me, thanks!

Please login or Register to Submit Answer