A dynamic chart where the user can apply filters on the categorical variables.
I would also like the related database to remain inaccessible to the user.
An example of such chart.
Software Recommendations Stack Exchange is a question and answer site for people seeking specific software recommendations. It only takes a minute to sign up.
Sign up to join this communityA dynamic chart where the user can apply filters on the categorical variables.
I would also like the related database to remain inaccessible to the user.
An example of such chart.
The Shiny app by the folks from RStudio helps you do that. It is a web application framework for your R analytics and code.
It helps you apply requisite filters which you can define, and you can decide on including the database access permissions too.
Similar to what Dawny mentioned above, there is also Plot.ly which you can use exactly like you would use Excel online. There is also a Powerpoint add-on to have the interactive graphs inside powerpoint presentations. Just in case you don't know, or don't want to learn R
(though you should, because Shiny is awesome).
And for the sake of completeness, the graph that you linked above was created using Google Charts, which you can use from R
and share on ShinyApps through RStudio really easily. The package is called GoogleVis.
Also if you're interested in learning about about interactive visualization in R
, I recently gave a talk on that subject, here are the slides and the RMarkdown can be found in the github repo.
Visually, that graph reminds me of flotplot, which is a javascript tool for plotting graphs which can be interactive. (Incidentally, I think they look much better than Excel graphs too.)
You can program any filtering routine you want, but you will probably have to do the implementation yourself. At least, I'm not aware of a connection between flotplot and an extensive math library like R.
Flotplot only sends the user the data needed to plot the curves, so users won't be able to access the whole database at once.
You can try Web Pivot Table. It is totally web based and run inside browsers and it has full functionalities as excel pivot table.
There are demo and Documents show you how to use it. Installation is quite simple and user interface is pretty intuitive.
It creates pivot table and pivot chart synchronizedly and support OLAP cube pivot as well.
It has two editions. Free edition is free for anyone or any company. Professional edition can be embedded into any other applications or software and need to purchase a license.