CA Service Management

  • 1.  Survey statistics by date periods

    Posted Feb 08, 2017 01:13 PM

    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



  • 2.  Re: Survey statistics by date periods

    Posted Feb 08, 2017 01:43 PM

    Hi Carlos,

     

    CA SDM is shipped with CABI. The following CABI reports are available for surveys:

     

    Survey Details

    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.

     

    Survey Summary 

    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.

     

    Kind Regards,

    Brian



  • 3.  Re: Survey statistics by date periods

    Posted Feb 09, 2017 03:22 AM

    Hi Brian

    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.

     

    Any idea?

    Thank you



  • 4.  Re: Survey statistics by date periods

    Posted Feb 09, 2017 04:07 AM

    Hi Carlos,

     

    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?

     

    Kind Regards,

    Brian



  • 5.  Re: Survey statistics by date periods

    Posted Feb 13, 2017 07:39 AM

    Hi Carlos,

     

    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

     

     

     

    Best Regards,

     

    Türker

     



  • 6.  Re: Survey statistics by date periods

    Posted Nov 20, 2017 03:54 PM

    Hi Brian,

     

    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?

     

    Thank you



  • 7.  Re: Survey statistics by date periods