How to calculate satisfactory level for Survey
We are considering the rating value (Score) in the calculation of the survey
Example :
Suppose the Survey has 7 Questions with maximum of 10 Radio type points and each points carry above mentioned score.
If customer clicks 9 for all 7 questions (that carry 5 score)
In such case the calculation will be : ((7*5)*100)/7*10 = 50 %.
Please note : Once the survey is published , we could not know the score configured for each question.
To know the score, use the below query :
The following query can be used to find the actual score value for the surveys and questions and the display value that they have configured for the radio option.
QUERY:
select sm.surveyname,sq.quesid,sq.questext,sro.optiontext as "Survey answer value", sro.multiplier as "Actual survey score" from survey_main sm inner join surveytoquestionmapping sqm on sm.surveyid = sqm.surveyid inner join survey_question sq on sqm.quesid = sq.quesid inner join survey_radio_option sro on sro.quesid = sq.quesid where sq.questype = 'Radio' order by sq.quesid,sro.multiplier;
New to ADSelfService Plus?
Related Articles
Qyery to bring Survey reports based on technicians , tickets, satisfactory level (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) 1. Login to SDP MSP as administrator 2. Execute this from SDP MSP application -> Reports -> New Query report select srrm.workorderid AS "Ticket Number",aau.FIRST_NAME as "Requester Name",srm.RESULT as ...Query to find deleted survey (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) Go to Reports >> New Query Report >> Run the below query to get the data SELECT err.message "System log message", err.errormodule "Module", err.suberrormodule "Sub Module", err.action "Action", ...Survey Mail Configuration -> To insert Survey link to a text
You can follow the below steps to remove the Good and Bad in the Mail Configuration and to insert the Survey Link in the desired text. -> Go to Admin -> Survey Email Configuration. -> Select the Good and Bad there and delete the same. -> Enter the ...How to schedule a Survey automatically after closing a ticket ?
We schedule a Survey after closing every ticket to know or rate our support to the customer. Steps to schedule a Survey: 1) Logo to the application as an administrator , In the Admin Tab -> Survey Configuration as shown in the below snapshot. -> In ...Query for disabling survey link when accessing non login url (or) requires login for filing survey
update globalconfig set paramvalue='true' where parameter like '%Requireslogin%' and category like '%survey%'