Helpful Votes gives the count of user stated yes, How to get the Total Helpful Votes (Yes + NO)

[er_anmolmittal]

Helpful Votes gives the count of user stated yes, How to get the Total Helpful Votes (Yes + NO).

This is required for Helpfulness KPI (Monitor the ratings on articles to gauge their effectiveness and relevance).

Formula: (Number of Helpful Votes / Total Number of Votes) * 100

[er_anmolmittal]

Helpful (No) can be taken as Useful (No) from Table KB_Feedback.

[er_anmolmittal]

Useful (No) can be used to get Helpful (no) from table kb_feedback.