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