Custom Report to Display top 20 view count records in reports from knowledge table

Manohar Reddy
Tera Contributor

‎05-15-2023 06:04 AM

Hi Team,

 

I want to create a Report where in it should display only top 20 most viewed articles.

 

Ex: If there are 100 articles the report should display only top 20 articles and hide everything. 

0 Helpfuls
  • 458 Views
6 REPLIES 6

Community Alums
Not applicable

‎05-15-2023 06:11 AM

Hi @Manohar Reddy ,

 You can create a Report using "kb_use" table and configure as per your requirement.

 

0 Helpfuls

Manohar Reddy
Tera Contributor
In response to Community Alums

‎05-15-2023 06:24 AM

Hi @Community Alums 

 

I don't see any option to limit the articles to 20. Could you please elaborate on what you are saying.

 

Thanks in Advance!

0 Helpfuls

Community Alums
Not applicable
In response to Manohar Reddy

‎05-15-2023 06:52 AM

Hi @Manohar Reddy ,

I don't think you can limit to show only 20 records!!

SandeepDutta_0-1684158739891.png

 

0 Helpfuls

Manohar Reddy
Tera Contributor
In response to Community Alums

‎05-15-2023 10:58 AM

Hi @Community Alums 

 

I am thinking if we can create a script include and call if in the report

0 Helpfuls