How to get second drilldown results based on the table chosen on report

[sana11]

Hi All, I have created a Basic Report in Servicenow (Eg: incident Table),

* Report type is Bar (Grouped By Assigned group) ,I have added 2 drill downs 

* whenever I perform onclick from bar chart , on anyone of assiged group its takes me to the drill down  where it shows pie chart of that particular assigned group tickets -this first drilldown is grouped by category

* whenever I perform onclick from first drill down piechart(clicking on particular category),its taking me to the list view of that particular ticket alone ,instead i want to  get all tickets related to that particular category

second drill down results also should be related with entire table not only from first drill down, can anyone please let me How can i achieve it?

[Juhi Poddar]

Hello @sana11 

• The drill-down behavior in ServiceNow reports filters the list based on the conditions at each level. At level 2, the list will be the cumulative condition from both level 1 and level 2.
• For example, if the "Assignment Group: Hardware" has 10 records at level 1, the pie chart at level 2 will be based on those 10 records only. If the "Category: Inquiry/Help" has 5 records out of those 10, only those 5 will be visible in the list view at level 2. This is the intended drill-down behavior.
• To achieve the desired behavior where the list view shows all tickets in the selected category, ignoring the filter from level 1, you would need to create a separate report.
• You can also embed this report within the current report as a secondary report for a more seamless experience.

Adding screenshots for better understanding

Hope this helps!

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps others find the solution more easily and supports the community!"

Thank You
Juhi Poddar

[Juhi Poddar]

Hello @sana11 

Thanks for marking my response as helpful.

Can you please mark this as an accepted solution as well so that it helps future readers to find the solution easily on community.

Thank You

Juhi Poddar