UI builder Data Visualization question

[gnewuser]

I have a page inside service operations workspace which has few reports with donuts. When some one clicks on the donuts I would like to display the records that match that condition.(like a drilldown report).

How do I achieve this? I have a page which has a data visualization with donut. How do I add another page with data passed from page one to page two.

any pointers or links to examples would be great

[debendudas]

Hi @gnewuser ,

Please refer this ServiceNow docs: Add a drilldown event to a data visualization in a technical dashboard (servicenow.com)

If this solution helps you then, mark it as accepted solution ‌‌✔️ and give thumbs up 👍! 

[gnewuser]

Thanks I followed this so the title and table part works from the previous page (which has the donuts) but the query is not getting applied. What could be the reason? It displays all the rows from the table and the query is not getting executed.

[debendudas]

Make sure you used the Optional parameter to pass the query

Optional parameters

{query:@payload.params.query, listTitle:@payload.title}

Please check the step 8 in the documentation.

[Dhana3 · Accepted solution]

You can add a simple list page from the servicenow templates in the UI builder experience. In the visualization events you'll find a event called visualization clicked. Once you select it, you will find an option to add what happens when visualization is clicked, like a + icon. If you click on the + icon you'll find an option to link to destination, there you can select the simple list page as destination, and you can pass the payload values as table name, query and title using payload.table option. You need to click on data option there.