Hi,

I have a simple MySQL table in my joomla database called: jos_NetworthQuartile

It only has one line:

ID QRank, ORank
1 20 80

My query in ArtioFusionCharts is simply:
SELECT Qrank, Orank FROM jos_NetworthQuartile

When I click "try" it says:
SQL Query OK. The chart was fill and render by new data.

Yet there's no actual chart, and when I put the module onto a page the page won't load.

Any ideas?

Which chart type did you use?
I see that result of sql query is just one line, so you want to show chart just with two values. I do not know how you defined columns in the chart. You may try to write:
SELECT Qrank as COLUMN_1, Orank as COLUMN_2 FROM jos_NetworthQuartile
to match sql output with chart. Of course, adjust COLUMN_12 as you need.

Hi,

I'm using a Stacked 3D chart.

I only want two values to create a bar chart showing a user's percentile.

So QRank is from 0 to 100, and ORank = 100 - QRank

I'm still not getting anything when I use the label modifications above. There is definitely data in my table.

Just as an FYI, using FusionCharts for Dreamweaver I was able to get this to work so I think my query is good. Not sure exactly what's happening though.

My connection looks good too as when I click "try" it gives me:
"SQL Query OK. The chart was fill and render by new data."

Could this be a permissions issue?

After spending more than a day on this I still cannot get anywhere.

Could you please help me with my issue? I still cannot use this product.

Well, I finally figured out the only way to get it to work was to modify the SQL to as follows:

SELECT 'Blank', 'Networth'
FROM jos_NetworthQuartile
UNION ALL
SELECT 'Blank', QRank
FROM jos_NetworthQuartile
UNION ALL
SELECT 'Blank', ORank
FROM jos_NetworthQuartile

Even though this should really be a 1-line SQL code since we're just creating the most basic chart.

Would be useful if there was a guide that actually walked through these areas and how to troubleshoot.

Would be even more useful if Support existed. Still, the product is a good bridge between FusionCharts and joomla.