Separate sql queries with ";" if you would like to use multiple queries to build comparison graphs. See example Some supported dynamic tags can be used in your query: {current_user_id},{current_user_login},{current_user_email},{current_user_display_name}.
Step 3: Set Arguments and Values for a Chart - See Example 1
and Example 2
Label for X axis:
This is just label text for query argument, you can type any desired name here.
SQL field name of X axis:
Write corresponding SQL field name here. f.e. display_name, post_date
Label for Y axis:
This is just label text for query's main value, you can type any desired name here.
Use ";" separated label names if you have more than one query inside SQL CODE field.
SQL field name of Y axis:
Write corresponding SQL field name here. f.e. post_count) - Use one single output name even if you have multiple queries in SQL CODE field.
By using this section you can create dynamic variables inside SQL code. It also creates corresponding dynamic input form above each chart. Show/Hide
Enter dynamic filter variables using the format described below:
Use this format: variable_name~default_value~variable_label~variable_type | variable_name~default_value~variable_label~variable_type etc.
variable_name - any single name you want.
default_value - default value when no any variable chosen by a user
variable_label - Label which would be visible at a form above the chart
variable_type - number, text or date
~ is a separator between variable elements.
| is a separator between variables
For example if to put limit_tag~10~Count~number | post_date_tag~2010-07-05 17:25:18~Date Published~date here,
then you can use this SQL code select * from wp_posts where post_date<{post_date_tag} limit {limit_tag} in SQL CODE field.
{post_date_tag} and {limit_tag} would be replaced with dynamic variables.
So, the plugin will automatically recognize it and put corresponding selectboxes above the chart.
Width and height (with px. don't type px itself, just numbers)
Color scheme (comma separated #RGB colors. f.e. #FF0000 or #00FF00,#BBCC00 ).
Leave empty if you want random colors
Legend block
ID, 'guaven_sqlcharts_legend_position', true);?>
Legend in a chart is Y values which usually appears at the top/right part of the graph
Note: WordPress supports MySQL only Databases, to use non-MySQL databases some custom PHP code&driver would be needed.
To discuss how to build that you can contact us.
Note: Shortcodes supports width and height attributes. F.e. [gvn_schart id="1" width="500" height="400"]. If no attributes, default width, height (which you enter in this page above) will be used.
Save Changes and See Live Demo
ID . '" '.(get_post_meta($post->ID,'guaven_sqlcharts_tablepart',true)!=''?' table="1"':'').']');
}
 . 'asset/img/pie.png';?>)