- Posts: 4984
- Thank you received: 1246
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Guidance on building a dashboard for one survey - how to access responses
Compared to other solutions the price is not that high. To high for us to justify exploring the stuff. SaaS via www.shinyapps.io/ would be 99 USD per month. That is cheapest with user authentication.holch wrote: Basically $10.000 per year. One can ony afford that when you have a lot of usage for this. Definitely not a solution for a few custom reports and dashboards per year for some surveys.
There are some other ideas around opensource shiny and thirdparty user-management.
www.r-bloggers.com/password-protect-shiny-apps/
I would like to see a addon for e.g.NextCloud to integrate Shiny. You have the usermanagement, you can offer up/downloads and with an additional click you could offer some shinyapps.
Plan B is leveraging on the upcoming notebook concept (R,Python) which is one file containing the data and the code. Still issues with encrypting data and a way to use live data. But for many applications you don't need data on respondent level.
@driz: You might be able to cosponsor a plugin or share the coding effort.
www.limesurvey.org/forum/plugins/108530-...vot-table-and-charts
Since Gabriel already open for quotation and Denis announced a open source plugin, you might ask for some insight where you could support the effort via money or code to get a dashboard.
It all depends on the budget you want to spent (money and time).
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
@jelo - dashboards are hyped in some areas, but in others they serve a real purpose, and make the results of surveys actionable and accessible to a whole organisation. To get a larger organisation to use the results to make improvements, a dashboard often is a lot more effective than static reporting.
So you got a larger organization as a client and you need a dashboard for them. Without any budget?driz wrote: To get a larger organisation to use the results to make improvements, a dashboard often is a lot more effective than static reporting.
In larger organizations I would expect a reporting platform like Qlik or Tableu. As long as Windows is available they often have a SQL Server and SQL Server Reporting Services.
I hope we will see some more input here about how and what a data dashboard should look like in connection with LimeSurvey.
If you want to stay close to MySQL and PHP you might check out small commercial packages like
dbface www.dbface.com/documents/ which is available for PHP. Not Opensource.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
I am directly involved with a tracker survey for customer experience (not my client) for which the ongoing costs are way more than the annual licence of R Shiny. It is a very straight forward and short survey, and a fairly simple dashboard.
With the amount of dashboard tools out there, I am not sure whether LS needs to provide this functionality. But it would be great if we can make the data accessible to programmers who then can build a dashboard on top of LS. Which brings me back to my original question - people are already building dashboards on LS, I would like to do the same but need to know how to access the data.
Thanks for pointing me towards dbface - has anyone used this successfully with LS? Before I dive in and buy a licence, it would be great to know which tables to point the software to.
- DenisChenu
-
- Offline
- LimeSurvey Community Team
-
- Posts: 13146
- Thank you received: 2423
GPL / AGPL don't mean Free like a beer, but like a speech ......
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.
- gabrieljenik
-
- Offline
- Official LimeSurvey Partner
-
- Posts: 272
- Thank you received: 45
If you are going to be working on the same server, I think direct DB access is a good choice.
Like a separate application that uses the Limesurvey DB as a data source.
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Checkout our Reporting Solutions and our plugin shop at www.encuesta.biz .
- DenisChenu
-
- Offline
- LimeSurvey Community Team
-
- Posts: 13146
- Thank you received: 2423
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.
a clean & quite easy way to provide charts is to use chart.js library ( chartjs.org )...
Note that all the features of this library are also available via clouflare's cdn:
cdnjs.cloudflare.com/ajax/libs/Chart.js/2.3.0/Chart.bundle.js
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
The problem with dashboards today, especially for market research and here especially in the adhoc area is, that you need to be able to create dashboards relatively simple and quick. If you have a continous survey over many years with no or little changes custom development might be an option. But I can't really start to create custom dashboards for each adhoc study.
If the costs of a dashboard is a lot higher than what the tools mentioned here cost, then the client should think about changing providers. Of course, if you need something really, really specific, then there is probably no way around custom creating a dashboard. But otherwise I would always go for one of those tools. The cost money, yes. But the developer also costs money and I assume that those plattforms are usually more robust than custom development.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Offering a usermanagement for reports/dashboard would be nice. Could be a page with html editor like when creating a question page. You could add javascript and html. Second step would be exposing data via an interface. That would be a lot more stable than accessing via MySQL directly via a thirdparty tool. Allowing public report via a customized link with usermanagement to limit access.holch wrote: I think today Limesurvey has everything that you need when you want to create your own dashboard. With access to the database you can basically do whatever you want with the data.
Reporting is more cruical than dashboard. Since LimeSurvey is going SaaS first, the competition in reporting and dashboard is no longer limited to open source. In SaaS surveyspace nobody cares about opensource.
A usermanagement around shiny server or other html/js tools sound like a viable step.
Is the usermanagment accessible via plugin api? Adding own permission sets isn't possible, is it?
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
- DenisChenu
-
- Offline
- LimeSurvey Community Team
-
- Posts: 13146
- Thank you received: 2423
In fact : remote control API use existing Permission of limesurvey, then use the same user on RC tool can be a solution.jelo wrote: ...
A usermanagement around shiny server or other html/js tools sound like a viable step.
Is the usermanagment accessible via plugin api? Adding own permission sets isn't possible, is it?
The RC tool for login use the RC API login system.
Maybe

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.
There is no mission statement, in which market LimeSurvey wants to play a role. LimeSurvey as a SaaS seems to play a more important role that OnPremise. The redesign of the Website and the new pricing seems to confirm that.driz wrote: With the amount of dashboard tools out there, I am not sure whether LS needs to provide this functionality.
In the SaaS space open source is less relevant for the buyer. So the competition is bigger and tougher.
E.g. SurveyGizmo offers a lot for 1,500 USD per year. No complete dashboard, but the integration of R scripts and Chartlibs into the reporting is very nice. help.surveygizmo.com/help/run-r-scripts-in-reports
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users