Create mouse-over hovers
Custom Bar Charts, created with the SQL Template Designer, can be configured to have a mouse-over on the bars to display the charted values.
Select .
Click the button.
Click the tab in the SQL Template Designer window.
Select the field that will become the displayed as a bar in the chart.
Click to launch the window where you will enter the syntax required for the mouse-over option.
In the Hover input box, enter the syntax for the value.
The fields from the query can be accessed using the ${} format to access the row context variable.
EXAMPLE
${row['field_name'].data} will supply the field_name value for the mouse-over.