Report filtered using ui builder

[aniketdani100]

I have developed a report using the UI builder for data visualization(pie chart), and I've also incorporated filtered conditions on the data source table. However, upon clicking the report, it does not navigate to the corresponding filtered view within ServiceNow.

Clicking on report elements should ideally direct users to the corresponding filtered list view of records.

Any assistance would be greatly appreciated.

[M Iftikhar]

Hi @aniketdani100,

1. In the UI Builder, choose the data visualization you want to add the drilldown to.

2. Please make sure in Data > Data update section "Enable drilldown" is checked.

3. In the configuration panel for the data visualization, go to the Events tab.

4. Add an Event Mapping by Click on + Add event mapping.

5. Select the Visualization Clicked event.

6. A dialog will appear showing a list of available event handlers. Select the Advanced dashboards - Redirect event handler.

7. Edit the Context Field:

• In the Context field, click Edit.
• In the editing dialog, select object JSON type.
• Click Add property and enter
  property name: path
  value: now/platform-analytics-workspace

8. In the Route field, enter simplelist to direct to the simplelist page within Platform Analytics.

9. Bind Data to the Route fields:

• Select Bind data for the Route fields.

• Add the property {table: @payload.params.table}. This will pass the name of the table from your visualization to the simplelist page.

10. Similarly, bind data for the Optional Parameters field.

• • Set the values {query: @payload.params.query, listTitle: @payload.title}.

  • For the query parameter, add {query: @payload.params.query}.

  • Add another input and enter {listTitle: @payload.title} in curly brackets.

11. After configuring the parameters, click Apply to save the changes.

Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution so others can benefit as well.