<p>This plugin adds a <strong>widget</strong> to display download statistics based on the <a href="https://wordpress.org/extend/plugins/wp-downloadcounter/" rel="ugc">Download Counter</a><br />
plugin on your site. The sidebar widget will show a highly configurable chart based on the<br />
<a href="http://code.google.com/apis/chart/" rel="nofollow ugc">Google Chart API</a>. Furthermore it offers a <strong>dashboard widget</strong> that summarizes your<br />
downloads, to get information quick at a glance.</p>
<p>The plugin supports following chart types:</p>
<ul>
<li>Bar (horizontal)</li>
<li>Pie </li>
<li>Pie 3D</li>
</ul>
<p>You can include a chart of your downloads on a <strong>page</strong> or in a <strong>post</strong> using the downloadcounterchart-<strong><em>shortcode</em></strong>.<br />
Of course a download chart is includable in your <strong>theme</strong>. See <a href="https://wordpress.org/extend/plugins/wp-downloadcounter-chart/other_notes/" rel="ugc">extended documentation</a><br />
for detailed explanations for that.</p>
<h3>Usage</h3>
<p>There are several ways to include a chart of your downloads on your site.</p>
<h4>Page / Post (Shortcode)</h4>
<pre>[downloadcounterchart chart_type="pie" chart_width="490" chart_height="190" label_color="000000" label_size="11" sqlcondition="" bar_color="0066CC90" bar_height="-1" bg_color="FFFFFF00"]</pre>
<p>Parameters:</p>
<ul>
<li><em>chart_type</em> – Type of the chart. Valid values: <code>bar_horizontal</code>, <code>pie</code> or <code>pie3d</code>.</li>
<li><em>chart_width</em> – Width of the chart image in px. May be about the 2.5 times size of the height for a pie chart.</li>
<li><em>chart_height</em> – Width of the chart image in px.</li>
<li><em>label_color</em> – Hex color value for labels, optional with additional opacity value (e.g. 50% black = 00000050).</li>
<li><em>label_size</em> – Font size of the labels.</li>
<li><em>sqlcondition</em> – Optional SQL where statement, leave blank for all downloads.</li>
<li><em>bar_height</em> – Bar chart only. You can explicitly set the bar height, but it may result in a chart that does not include<br />
all data, if the chart height is not big enough. Recommend to set <code>-1</code> for auto-sizing.</li>
<li><em>bg_color</em> – Background color. Hex color value, optional with additional opacity value (e.g. transparent = FFFFFF00)</li>
</ul>
<h4>Theme</h4>
<pre>downloadcounterchart_img($chart_type, $chart_width, $chart_height, $label_color = '333333', $label_size = '11', $sqlcondition = '', $bar_color='', $bar_height='', $bg_color='')</pre>
<p>Parameters:</p>
<p>see section above</p>
<p>Example:</p>
<pre>if (function_exists('downloadcounterchart_img') && class_exists('DownloadCounterChartApi')){
    downloadcounterchart_img(DLC_CHART_PIE, 490, 190, '000000', '11', '', '0066CC', '-1', 'FFFFFF00');
}</pre>


Download Counter Chart

Visualization of your downloads based on the Download Counter plugin.

Guaven Labs

<p>The plugin can create beautiful charts based on your SQL queries, then you can use those charts in any part of your website.<br />
You can use both native wp and non-wp mysql tables in your queries.</p>
<h3>Pie chart, Donut chart, Line chart, Bar chart, Column chart, Area chart</h3>
<h4>How to use</h4>
<ol>
<li>
<p>Give any name to your report.</p>
</li>
<li>
<p>Use our preinstalled chart or create new one yourself: choose desired chart type, type sql query,<br />
enter field names, labels and then press to Publish/Update</p>
</li>
<li>
<p>You can use multiple SQL queries too. Just split them by ; sign. You can also add shortcode argument to SQL query. For example if you<br />
type “select * from wp_posts where ID>{arg1}” then it you can pass arg1 value to the query with  [gvn_schart_2 id=”2″ arg1=”11″] shortcode.</p>
</li>
<li>
<p>After update/save you will see needed shortcode below there. You can use that shortcode anywhere in your website: in pages, posts, widgets etc.</p>
</li>
<li>
<p>Just check “Show table-view data below the graph” in order to get table-list view below each chart.</p>
</li>
<li>
<p>Using “Dynamic Filters” you can create dynamic variables inside SQL code. It also creates corresponding dynamic input form above each chart.</p>
</li>
</ol>
<h4>Dynamic filters</h4>
<p>Use this format: variable_name~default_value~variable_label~variable_type | variable_name~default_value~variable_label~variable_type etc.</p>
<ul>
<li>variable_name – any single name you want.</li>
<li>default_value – default value when no any variable chosen by a user</li>
<li>variable_label – Label which would be visible at a form above the chart</li>
<li>variable_type – number, text or date</li>
<li>~ is a separator between variable elements.</li>
<li>| is a separator between variables</li>
</ul>
<p>For example if to put</p>
<p>limit_tag~10~Count~number | post_date_tag~2010-07-05 17:25:18~Date Published~date,</p>
<p>then you can use this SQL code</p>
<p>select * from wp_posts where post_date<{post_date_tag} limit {limit_tag}</p>
<p>in SQL CODE field.<br />
{post_date_tag} and {limit_tag} would be replaced with dynamic variables.</p>
<p>So, the plugin will automatically recognize it and put corresponding selectboxes above the chart.</p>
<h4>Website</h4>
<p><a href="https://guaven.com/my-sql-charts/" rel="nofollow ugc">https://guaven.com/my-sql-charts/</a></p>
<h4>Documentation</h4>
<p><a href="https://guaven.com/my-sql-charts/#docs" rel="nofollow ugc">https://guaven.com/my-sql-charts/#docs</a></p>
<h4>Bug Submission and Forum Support</h4>
<p><a href="https://guaven.com/contact/solution-request/" rel="nofollow ugc">Contact Page</a></p>
<h4>Please Vote if you liked our plugin</h4>
<p>Your votes really helps us. Thanks.</p>
<h3>Available Filters</h3>
<p>apply_filters( ‘guaven_sqlcharts_table_empty_cell’);</p>
<p>apply_filters(‘guaven_sqlcharts_pre_print_vars’);</p>
<p>apply_filters( ‘guaven_sqlcharts_final_output’);</p>
<p>apply_filters(‘guaven_sqlcharts_rendered_sql’);</p>


SQL Chart Builder

Unfortunately, this plugin is only useful for very specific use-cases, because it supports ONLY two database fields (i.e. X and Y axis, which almost never makes sense for the supported pie chart type but anyway). The external MySQL connector works well, so that part is great, but the shortcode doesn't output the charts and the "preview" doesn't honor the width and height settings. So, this could have been great, with just a little more love and attention. Ah well.

I had such high hopes :(

Turn Your SQL Queries to Beautiful Dynamic Charts- Pie, Line, Area, Donut, Bar Charts with date/input filters.

Download Counter Chart vs SQL Chart Builder