Report drill down not working in UI buiilder

Geetika4
Mega Expert

Hello,

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

find_real_file.pngI 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.

1 ACCEPTED SOLUTION

Geetika4
Mega Expert

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 😉 😞

find_real_file.png
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

12 REPLIES 12

catho
Tera Expert

Thanks @Geetika for that answer - I was stuck on that too.

 

Looking at the SN Developer site - they now have some relevant exercises:

 

1) Open Lists from a Data Visualization 

 

2) Making Events Dynamic (eg slice of a pie chart)



I'm interested to see how the community responds as more people start using UI builder.

 

Being able to do so much with the event handler is fantastic - but not having the option to build a simple report to click into to see the relevant records is going to add so much extra time for me.

jeffrubinoff
ServiceNow Employee
ServiceNow Employee

Is there no possibility to create a dashboard in the in-line editor and put the resulting dashboard component on a page built from the Dashboards template in your workspace? That would give you pre-configured drilldown events.

SagarBhadke
Tera Contributor

Hey @Geetika4 ,

I m using Heatmap visualization and in that created a metric on Case Table where the metric is like Created and Updated vs HR Service.

But When I get the count in Heatmap its correct on Visual, but as soon as Drilling down i m getting the wrong count i.e. list of cases

attaching the snapshot of it. 

SagarBhadke_0-1721908049753.png

Suppose i click on the "99" then its giving me the o/p in list as 

SagarBhadke_1-1721908120834.png

I tried your approach to create another client script, but I m unable to figure out how to do that in new version 

SagarBhadke_2-1721908222106.png

Please help me with this, How should i solve this ? 

Its real-time scenario.