No Axes on Line Chart (Query has Group By)
-
First of all, many thanks for offering support on the free version of this plugin.
I am having an issue whereby the axes (or headers) of line charts are not displayed when queries use GROUP BY. Specifically:
SELECT column FROM table WHERE wp_id = {{{user_ID}}} – line chart works fine
SELECT ROUND(AVG(value),2) FROM table WHERE wp_id = {{{user_ID}}} GROUP BY MID(label,1,10) – line chart displays value series fine but only the first label and no axes
The issue does not affect the axes of a bar chart. Also, the x-axis labels do not rotate on the line chart.
Thanks again for your time
- The topic ‘No Axes on Line Chart (Query has Group By)’ is closed to new replies.