Hi to all
we are starting with surveys. In other question finally we found (thans to responses of you) the way to make question responses horizontally.
Now we have the main survey ready to start. And now, we are looking for a way to have statistics of the survey.
We have found information in technical reference, and we know that there's a table (survey_stats) where remains the number of tiquets "evaluated" and the number of surveys sent for every survey. Then, why about dates of all this information.
The other tables about surveys only take data when a user answerd his survey. For example, if you have sent a survey to a user, there's no registered anywhere. When the user access to respond, then his response is registered at many tables: survey_question, survey_answer and survey. But if the user doesn't respond, you loose this information.
I need to know:
How many surveys has sent CASDM every month? And how many of them have been answered by users?
If anyone have a little idea, it would be so helpfully
Thanks to all
CA SDM is shipped with CABI. The following CABI reports are available for surveys:
This report shows details of a given Survey name (or ALL) that lists the specifics of each Survey completed. It will look very similar to the actual Survey, but filled in with the Customers choices and comments.
This report shows a summary of a given Survey name (or ALL) that lists the percentages and counts of responses for each answer, per question, based on the total number of responses for this Survey.
Survey Summary with Comments
This report shows a summary of a given Survey name (or ALL) that lists the percentages and counts of responses for each answer, per question, based on the total number of responses for this Survey. Includes Customer Comments.
Based on the descriptions, it looks like the Survey Summary and\or Survey Summary with Comments report should somewhat meet your requirement.
thanks for your comment, you are right but there's not enough. We want to know this numbers evolution month by month. Just like this
January February March April June ...
Survey sent: 392 427 581 822 901
Survey answered 85 98 110 145 223
Satisfaction index 4,7 4,4 4,4 4,8 4,7
Then, the "satisfaction index" is calculated by answers, and, because we have the received date at table survey_answer, is possible to calculate the evolution mont by month.
The same occurs with the "survey answered", because with the same "received date" we can obtain this numbers.
But there's no way to obtain the first line, because there aren't anywhere data about survey's sent if there aren't answered.
If the OOTB report does not meet your requirement, typically you would then need to write a custom report either via SQL means or a WEBI report.
Hope that steers you in the right direction?
I give an idea for this.
We measure the satisfaction of our employees with BS services as monthly performance by survey which sent after the close incidents and requests.
we collect to survey data on a custom .htmpl file to use <PDM_LIST> tags. Using the data we have obtained in the necessary functions, we generate the following report. Line chart is showing the monthly performans of employee satisfaction. Pie charts is showing rating of survey answers
Does these report come with CABI 6.2 or 6.3? Because I haven't found them in CABI 6.2 (production environment) or CABi 6.3 (test environment) and I installed all that was included in the bundle a while ago.
Or is it possible to download these report Template somewhere?
Loading Survey - Survey_Answer_Template - svy_atpl
Loading Survey - survey_template svy_tpl
Loading Survey - Survey_Question_Template - svy_qtpl