====== datagraph Plugin ======

---- plugin ----
description: DokuWiki plugin visualizing data from the Data Plugin as graphs directly accessing the SQLite database
author     : Julian Kunkel
email      : JulianKunkel@googlemail.com
type       : syntax
lastupdate : 2016-05-07
compatible : Detritus
depends    : sqlite, translation, data, c3chart
conflicts  : 
similar    : 
tags       : graph, data, chart

downloadurl: https://github.com/JulianKunkel/dokuwiki-datagraph/zipball/master
bugtracker : https://github.com/JulianKunkel/dokuwiki-datagraph/issues
sourcerepo : https://github.com/JulianKunkel/dokuwiki-datagraph
donationurl: 

screenshot_img : https://trello.com/1/cards/6373e1e5919d0e01bf7d2c7a/attachments/6373e21ca2a613021af5de0a/download/datagraph.png
----

The plugin queries the SQL database created by the data plugin, aggregates data from a specified class of pages. The aggregation results are then output in the syntax needed by the c3chart plugin and, thus, visualized using that plugin (if available).

The plugin allows page visitors to select the aggregator and the grouping and change them.


===== Installation =====

The plugin comes without any warranty but I hope it is useful for other people. It needs certain sanity checks to be useful in public pages.

Search and install the plugin using the [[plugin:extension|Extension Manager]]. Refer to [[:Plugins]] on how to install plugins manually.


===== Examples/Usage =====

See the plugin in action [[http://www.vi4io.org/hpsl/start|here]].

It allows users to change the aggregation and grouping of the SQL query.

<code>
---- datagraph ----
group by  : system vendor
aggregate : storage capacity
digits    : 0
filter    : class="sites", year="2016"
choosableAggregates : compute peak, memory capacity
choosableGroups     : system vendor, nationality
----
</code>