Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Responses versus out of total survey triggered

Mounika30
Kilo Sage

how to do the survey report using Performance analytics.

 

Report to show % of responses out of total survey triggered.

Responses/total surveys sent using PA. How to approach this? 

1 REPLY 1

Mounika30
Kilo Sage

I have created an

indicator source (asmt_assessment_instance) for --total survey sent (added filter created on this month)

Indicator source (asmt_metric_result) for -survey responses(added filter created on this month).

 

But for Every survey triggers , a record is inserted in asmt_assessment_instance table

but in the asmt_metric_result (2 0r 3 records) are inserted based on question responded by the user.

For example:

asmt_assessment_instance---22 records

asmt_metric_result ---45 records

Formula indicator= Survey resposes/total survey sent will be 45/22=3.75

which is not correct . Could anyone help me on this