Average Report

[RANSINGH1]

Hi All,

How to create average score report for total number of Vulnerable items/Distinct count of CI. Table name sn_vul_vulnerable_item

I tried to create a calculated column but what could be the return type as these are not direct number fields but needs result based on their count and then average. 

[AndersBGS · Accepted solution]

Hi @RANSINGH1 ,

it sounds like a job for performance analytics as you’re trying to calculate the average based on multiple records

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders