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 ...Calculate Risk Score based on a custom questionnaire
UseCase: Risk score has to be set based on the response for a custom questionnaire populated in a form. Note: The form is adaptable based on specific needs, this version serves as a sample questionnaire with predefined risk values defined within the ...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 ...Calculate Risk Score based on a custom questionnaire configured in resource section
UseCase: Risk score has to be set based on the response for a custom questionnaire. Because the Change module does not offer resource sections like the Service Request module does, this requirement may take the majority of the available additional ...