Title: Mark Cookson's Replies | WordPress.org

---

# Mark Cookson

  [  ](https://wordpress.org/support/users/mark-cookson/)

 *   [Profile](https://wordpress.org/support/users/mark-cookson/)
 *   [Topics Started](https://wordpress.org/support/users/mark-cookson/topics/)
 *   [Replies Created](https://wordpress.org/support/users/mark-cookson/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/mark-cookson/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/mark-cookson/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/mark-cookson/engagements/)
 *   [Favorites](https://wordpress.org/support/users/mark-cookson/favorites/)

 Search replies:

## Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Business Intelligence Lite] Chart bars overlapping](https://wordpress.org/support/topic/chart-bars-overlapping/)
 *  Thread Starter [Mark Cookson](https://wordpress.org/support/users/mark-cookson/)
 * (@mark-cookson)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/chart-bars-overlapping/#post-3929528)
 * Hi Claudio
 * Thanks for your response. I worked it out in the end. I thought the title in 
   the interface was setting the ID but it wasn’t. I took the ID from the URL and
   it worked fine.
 * Thanks for you help. Great plugin!
 * Mark
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Business Intelligence Lite] Chart bars overlapping](https://wordpress.org/support/topic/chart-bars-overlapping/)
 *  Thread Starter [Mark Cookson](https://wordpress.org/support/users/mark-cookson/)
 * (@mark-cookson)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/chart-bars-overlapping/#post-3929471)
 * Hi Claudio
 * Thank you for your quick response.
 * the query and chart seem to work fine in the admin dashboard but don’t show anything
   on the page. The query is: (N is a null value)
 *     ```
       select ifnull (N, "All Fights") as Finish, count(finish) as Number from test_prefixtblfight
       union
       select ifnull (N, "KO") as Finish, count(finish) from test_prefixtblfight where finish like "%KO%"
       union
       select ifnull (N, "Submission"), count(finish) from test_prefixtblfight where finish like "%submission%"
       union
       select ifnull (N, "Decision"), count(decision) from test_prefixtblfight where decision like "%yes%"
       union
       select ifnull (N, "Draw"), count(draw) from test_prefixtblfight where draw like "%yes%"
       union
       select ifnull (N, "No Contest"), count(no_contest) from test_prefixtblfight where no_contest like "%contest%"
       ```
   
 * which produces the correct results. From this query I built a chart and this 
   displays correctly in the admin dashboard.
 * I added
 * wpbusinessintelligence id=”2″ type=”chart” iframe=”n” ] finishes [/wpbusinessintelligence]
   `
 * to the page but nothing shows up on the final page.
 * Do you know what the problem might be.
 * Thanks again.
 * Mark
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Business Intelligence Lite] Chart bars overlapping](https://wordpress.org/support/topic/chart-bars-overlapping/)
 *  Thread Starter [Mark Cookson](https://wordpress.org/support/users/mark-cookson/)
 * (@mark-cookson)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/chart-bars-overlapping/#post-3929455)
 * Claudio
 * Thank you for your help. The chart now displays correctly in testing. I have 
   managed to produce four columns representing the values I wanted.
 * Unfortunately, the chart doesn’t display correctly on the live webpage. I get
   an error:
    “Uncaught SyntaxError: Unexpected token ;” at line 105 on the below
   page.
 * [http://mmadb.rodderscode.co.uk/charts/](http://mmadb.rodderscode.co.uk/charts)
 * Any help would be much appreciated.
 * Thanks
 * Mark
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Business Intelligence Lite] Chart bars overlapping](https://wordpress.org/support/topic/chart-bars-overlapping/)
 *  Thread Starter [Mark Cookson](https://wordpress.org/support/users/mark-cookson/)
 * (@mark-cookson)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/chart-bars-overlapping/#post-3929401)
 * Thanks Claudio
 * If I understand you correctly. WP Business Intelligence reads tables horizontally
   ie it takes the first column in the table as the label, the second as the number.
   Is that correct?
 * Thanks in advance
 * Mark

Viewing 4 replies - 1 through 4 (of 4 total)