How to create a Interactive filter to filter the report based on country

Community Alums
Not applicable

‎08-16-2023 02:19 AM

Hi All,

 

We have a OOB AI search dashboard. In that dashboard we need to create a interactive filter that shows the AI search result based on the logged in User country.

sangeetha10_0-1692176707575.png

 

Is this possible to do

 

Anyone can please help

Thanks.

0 Helpfuls
  • 702 Views
2 REPLIES 2

SwarnadeepNandy
Mega Sage

‎08-16-2023 04:14 AM

Hello @Community Alums ,

 

To create an interactive filter to filter the report based on the country of the logged in user, you need to do the following steps:

  • Create a custom interactive filter widget that uses the sys_user table and the country field as the source. You can use the Create a custom interactive filter widget article as a reference for creating and configuring custom interactive filters.
  • Add the custom interactive filter widget to the AI search dashboard. You can use the [Add an interactive filter to a dashboard] article as a guide for adding interactive filters to dashboards.
  • Configure the report widgets on the AI search dashboard to use the custom interactive filter as a filter condition. You can use the [Configure a report widget to use an interactive filter] article as a guide for configuring report widgets to use interactive filters.
  • Optionally, you can also set the default value of the custom interactive filter to match the country of the logged in user. You can use the [Set default values for an interactive filter] article as a guide for setting default values for interactive filters.

By following these steps, you should be able to create an interactive filter that shows the AI search results based on the logged in user’s country.

 

I hope this helps.

 

Kind Regards,

Swarnadeep Nandy

0 Helpfuls