Hi,

I'm working on an employee survey. Is there a way for LimeSurvey to automatically email a summary report to managers for their employees, such as on the 1st day of each month for the prior month? Same for quarterly and annual summaries.

It's a deal breaker if managers have to log in to search for this, our goal is to make it as easy to use for managers as possible, so send it to them automatically, instead of giving them more to do to get the results.

We can assume that we've uploaded a CSV file with the employee names, Unique ID, start date, end date, job title, duties, manager, and location, and that we've texted out at least one survey in that time period that has been completed.

What can be available in this automatic summary beyond a summary of the responses (e.g. "For question #3 the average response was 4.5")? Can we get such data as a response rate? If there are any questions consistently skipped? Can we alert managers to any red flags based on conditions? For example, set a red flag if more than 5% of employees in a given department rate their job satisfaction as below average as reported on question 4. What other data or analyses can we provide to managers to address employee responses?

If this is possible, how is it set up? Any help would be warmly appreciated!

Thanks,

Russ Conte

Hi,

Existing plugin : extensions.sondages.pro/export-statistic...on-and-satisfaction/
Seem near

Thank you very much! I didn't even think to look in plug-ins!

Best wishes,

Russ Conte

Hi,
in my opinion the best way is to develop your own application based on the LimeSurvey API or with direct access to the database.
The use a cron job to run it and send the results.

Can we get such data as a response rate?

Of course. You know the number of invitation, number of started interviews, number of completed interviews.

If there are any questions consistently skipped?

If a question is skipped there must be a condition why it is skipped. So you know the number of answers to this "condition question".

Can we alert managers to any red flags based on conditions? For example, set a red flag if more than 5% of employees in a given department rate their job satisfaction as below average as reported on question 4.

Same as before. Calculate the percentage of answers below that average.

What other data or analyses can we provide to managers to address employee responses?

How can we know the objectives of your survey. IMO this has to be provided by them.

Best regards
Joffm

Some examples:

Joffm wrote: in my opinion the best way is to develop your own application based on the LimeSurvey API or with direct access to the database.

Nice examples. What technology stack was used there? E.g. how was authentication (restriction to dashboard) solved?

@Jelo,
this is a prototype to show what is possible to a client. Therefore there are many different chart types.
It's a php script with direct access to the database, charts are Highchart.

The application is thought to be customized for each client and each survey.
Not a general one.

Joffm

If you want to know more, let's continue in German.

Thanks. I got my answers (direct PHP -> DB, Highchart, no user management).

Joffm wrote: It's a php script with direct access to the database, charts are Highchart.

Hey Joff, looks like we are following a pretty similar approach. We have also created half a dozen dashboard based on Highcharts. The data is read directly from the Limesurvey database and is presented using different chart types. For logging in to the dashboard we are checking Limesurvey user accounts and the "view statistics" rights of these user. Some examples:

Mazi wrote: Hey Joff, looks like we are following a pretty similar approach.

Seems to be the only approach for real world scenarios. I'm still waiting to see a complete dashboard via remote API. The restrictions seems to be too high for that.

One central dash, which connects to N LimeSurvey installations would be interesting.

In my opinion, have a real and adapted dashbord using API and an existing system to construct dashboard is the only way to have something really adapated.

We can do better in LimeSurvey to have «simple dashboard» :

For example :
1. Choice of sorting : «flat sorting» or «cross sorting»
2. Question choose for sorting
3. Advanced : filter by (start by one question signe choice)
4. Choice of view : Graph type and/or text type

But after i think a real solution is always need : usage of shiny.rstudio.com/ with R export for example.
If another solution exist and need a specific export : it can be done in plugin

Shiny seems to be a good one, but the open source server seems to have some quite important limitations (no user management/password protection), but I might read this table wrong:
www.rstudio.com/products/shiny/shiny-server/

Now Shiny Server Pro seems to be quite expensive and thus prohibitive for many Limesurvey users, I think (heard of something like Euro 10.000 for a license or so?).

The remote API seems to be lacking too much at the moment.

If the development strategy of LimeSurvey is aligned to SaaS users, I see more code directly placed into the core around the current statistics part.

As long as the remote API is not heavily used by SaaS functionality, it's up to a few sponsored features.