Tip: press Ctrl+Space for suggestions at any point. Separate multiple queries with ; to build comparison charts.
Supported dynamic tags: {current_user_id}, {current_user_login}, {current_user_email}, {current_user_display_name}
— plus every filter you define in the Input Filters tab.
Tell the chart which query column goes to which axis. The dropdowns are filled with the columns found in your SQL query above.
Each filter becomes an input field above your chart at the front-end, and a {tag} placed inside the SQL query.
The tag dropdown suggests {tags} already written in your query and columns from its WHERE part.
Example: pick or type fromdate with type date, click "Insert into query" and complete the condition, e.g. WHERE post_date > {fromdate}.
Raw format: name~default~label~type | name~default~label~type (type: text, number or date)
One color per data series (or per slice for circular charts). Leave empty to use the built-in palette.
Date/time scaling places each point by real elapsed time instead of equal steps. X values must be dates such as
2024-02-23, 2024-02, 2024 or 2024-02-23 14:30. If any X value is not a date, the normal axis is used.
Bars are sized from the closest pair of dates, so very uneven gaps produce thin bars.
Leave all fields empty to use this WordPress site's own database.
Note: Shortcodes support width and height attributes, f.e. [gvn_schart id="1" width="500" height="400"]. Without attributes, the width/height from the Style tab is used.
ID), $gvnsql_argtags);
$gvnsql_argtags = array_unique($gvnsql_argtags[1]);
sort($gvnsql_argtags);
if (!empty($gvnsql_argtags)) {
$gvnsql_argexample = '';
foreach ($gvnsql_argtags as $gvnsql_argn) $gvnsql_argexample .= ' arg' . (int) $gvnsql_argn . '="..."';
?>
This query uses shortcode arguments. Pass the values in the shortcode:
[gvn_schart id="ID); ?>"].
The live preview below runs without them (every {arg} is 0), so check the real result on a page or post.