Generate Employee Engagement Level Automaticly

More
4 years 1 week ago #101531 by anakinskywlkr
anakinskywlkr created the topic: Generate Employee Engagement Level Automaticly
First off all, hello all.

I've been stumbled upon Lime Survey for a day. I'm exploring this software for a while and found almost everything I need. I need to run Employee Engagement Level Survey at my organization. Yeah, I'm sort kind of IT guy. :laugh:

I wonder is it possible to make an custom saved query that shows on Responses & statistic menu? I asked by HR to display Engagement Level and I've search it through the forum. I can't find it.

I heard the formula is quite simple (CMIIW):

Engagement Level = total points/maximum points

I wonder if I could make some equation like this as query and save it for regular access.

At this moment, I can't access the manual's wiki, so some help would be very appreciated.

Thank's in advance guys!

Please Log in to join the conversation.

More
4 years 1 week ago #101536 by holch
holch replied the topic: Generate Employee Engagement Level Automaticly
Why can't you access the manual wiki? Ohh, I see, there is an error message.

With a Expression you should be able to read the two figures, calculate the Engagement level and write it into a hidden question to store it in the database.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
4 years 1 week ago #101538 by anakinskywlkr
anakinskywlkr replied the topic: Generate Employee Engagement Level Automaticly
Thanks for the respond!

Yup, I got an error message like this:
1A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "". Database returned error "1142: SELECT command denied to user 'c1manual'@'localhost' for table 'jos_banner' (localhost)".


An update: I managed to access wiki through manual.limesurvey.org/?page=English+Instructions+for+LimeSurvey and peek some manuals that I thought would be used. Is it done by Expression Manager?

Can I save it for regular access somewhere in reporting?

In general, I also need to make some custom report. A reporting that consisted from several set of fields that can be accessed frequently. I guess this Employee Engagement is one of that kind.

Please Log in to join the conversation.

More
4 years 1 week ago #101539 by holch
holch replied the topic: Generate Employee Engagement Level Automaticly
In order to have the calculated value available, you need to write it (probably via Javascript) in a question (text) that was hidden via CSS (not via the option "always hide question"), because then Javascript can not write to it.

If the result is not written into a question, then it will be lost. If you have to create a custom report anyway, you might just calculate the value for this report then and you do not need to write it into the database.

But for the custom report, you probably need to write your own script, because I don't think that Limesurvey allows custom reports.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!