Report drill down not working in UI buiilder

Geetika4 · ‎11-26-2021

Hello,

I created a page in "CSM/FSM Configurable Workspace" which looks something like below :

I have added multiple tabs and added different reports in it. Basically this page is supposed work as dashboard.
I noticed that report drill down is not working on this page.
This seems to be a major roadblock for me.

There is "Enable drilldown" option which is activated in these Data Visualization components still it doesnt work.
Please let me know if there is some solution to it.

Thanks in advance.

Geetika4 · ‎11-28-2021

Hey all,

After some digging I was able to figure this out, @Brad Tilton if you could add anything to it , please do so.

It appears enabling drill down is not enough we need to configure what happens when visualizations are clicked, So I added an event handler "Link to destination" under visualization and added the routing info as below (got this idea from an oob page 😉 😞

Also I tested it for different visualization like single score, pie chart, bar graph etc, same configuration works for all of them.

Still I do feel, this is something which should be auto configured, because in case of large number of reports in a page, this becomes repetitive practice.

View solution in original post

Drew Carpenter · ‎01-17-2023

If 'clickable' is checked and the event is correct, why would the visualization STILL not behave correctly?

Manoj Kumar Kda · ‎05-22-2023

Does this issue appear to be being addressed in Tokyo release? I have been struggling to enable drill-down options using the Technical Editor option. When configuring the event handler for my single score visualization, I do not see the option to Link to destination.

Bhanu Kiran · ‎06-14-2024

even I am not seeing link to destination, I am trying on Washington

Arjun11 · ‎08-18-2023

Hey @Geetika4 ,

Thanks for this. I was stuck with a similar issue.

Usually, when simple-list visualization is pulled on the landing page, the events are automatically created. But for a few, they weren't and this article helped.

Aniko Hegedus · ‎11-24-2023

Hello Geetika4!

Thanks for providing a solution.
In fact, these exact steps were not working for me, but you gave a good inspiration and in the end this is how I managed to make it work:
1. Created the list under "My lists" that I want to see if I click on the drilldown and copied the "tiny-id" part of the url

2. Then added a "Link to destination" event handler, just like you did, but the details were different. Probably, because my shell is Base Experience Shell, not Blank App Shell like yours.
Route: /list

List id: @payload.params.table.sys_id

Tinyid: the tiny id copied from the previous step

This way if I click on the single score figure, I am redirected to the lists with the correct table and filters.

Thanks a lot for your help! 🙂

Aniko