Mark Cookson

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

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

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.

https://mmadb.rodderscode.co.uk/charts/

Any help would be much appreciated.

Thanks

Mark

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