Support » Plugin: WP Business Intelligence Lite » No Axes on Line Chart (Query has Group By)

  • yanos

    (@yanoverfieldshaw)


    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

    • This topic was modified 4 years, 8 months ago by yanos.
  • The topic ‘No Axes on Line Chart (Query has Group By)’ is closed to new replies.