- Posts: 8
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Automatically email a monthly summary report to managers?
- russconte
- Topic Author
- Offline
- New Member
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
- DenisChenu
- Offline
- LimeSurvey Community Team
- Posts: 13647
- Thank you received: 2491
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
- russconte
- Topic Author
- Offline
- New Member
- Posts: 8
- Thank you received: 0
Best wishes,
Russ Conte
- Joffm
- Away
- LimeSurvey Community Team
- Posts: 12933
- Thank you received: 3979
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.
Of course. You know the number of invitation, number of started interviews, number of completed interviews.Can we get such data as a response rate?
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".If there are any questions consistently skipped?
Same as before. Calculate the percentage of answers below that average.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.
How can we know the objectives of your survey. IMO this has to be provided by them.What other data or analyses can we provide to managers to address employee responses?
Best regards
Joffm
Some examples:
Volunteers are not paid.
Not because they are worthless, but because they are priceless
- jelo
- Offline
- Platinum Member
- Posts: 5033
- Thank you received: 1257
Nice examples. What technology stack was used there? E.g. how was authentication (restriction to dashboard) solved?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.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
- Joffm
- Away
- LimeSurvey Community Team
- Posts: 12933
- Thank you received: 3979
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.
Volunteers are not paid.
Not because they are worthless, but because they are priceless
- jelo
- Offline
- Platinum Member
- Posts: 5033
- Thank you received: 1257
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
- Mazi
- Offline
- Official LimeSurvey Partner
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:
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
- jelo
- Offline
- Platinum Member
- Posts: 5033
- Thank you received: 1257
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.Mazi wrote: Hey Joff, looks like we are following a pretty similar approach.
One central dash, which connects to N LimeSurvey installations would be interesting.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
- DenisChenu
- Offline
- LimeSurvey Community Team
- Posts: 13647
- Thank you received: 2491
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
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
- holch
- Away
- LimeSurvey Community Team
- Posts: 11658
- Thank you received: 2742
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?).
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
- jelo
- Offline
- Platinum Member
- Posts: 5033
- Thank you received: 1257
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.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users