Knowledge View Count

[cw82uk]

Hi,

I am using the kb_use table to report on knowledge articles views.

I use this table as the 'viewed' column in the kb_knowledge table resets after 30 days (as per sys property).

kb_use creates a single record each time a user views a record and the data is never removed.

I managed to produce a bar chart but due to the number of articles the chart groups anything with less than 3 views under other in a huge stack at the end.

Does anyone know how I could update my report conditions to only shows articles with >3 or >4 views, in other words articles with less than 3 records in the kb_use table?

Thank You

[Robbie]

Hi @cw82uk,

Add an additional condition using the 'Times viewed' field/column and 'greater than' 3 to meet this requirement.

See below:

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.


Thanks, Robbie