Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Unable to render chart
(1 viewing) (1) Guest
Flash chart component for Joomla CMS.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1
  • 2

TOPIC: Unable to render chart

Unable to render chart 11 years, 7 months ago #32212

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?
The topic has been locked.

Re: Unable to render chart 11 years, 7 months ago #32223

  • lubi
  • OFFLINE
  • Posts: 221
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.
ARTIO Support Team
The topic has been locked.

Re: Unable to render chart 11 years, 7 months ago #32224

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.
The topic has been locked.

Re: Unable to render chart 11 years, 7 months ago #32225

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?
The topic has been locked.

Re: Unable to render chart 11 years, 7 months ago #32241

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.
The topic has been locked.

Re: Unable to render chart 11 years, 7 months ago #32247

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.
The topic has been locked.
  • Page:
  • 1
  • 2
User Login Empty