This is a pretty simple problem, but the solution is way beyond me, so that is why I posted this question in the hope you can help me solve it.

I have a table that looks like this:


I have a page that looks like this:


What I want is a combination chart like this:


So, what is the question?

How can I add the selected record from the page, using the Nr. link to the Table in the first image on a temporary basis to display a chart like the combination chart above? What do I need to change in my query to achieve that? See the image below:


There is one additional problem. Why is the first row in the table always left out? The Top observation is never included in the query other than using the values as Category names.

Looking forward to your suggestions.

Hello,

These combination charts are problematic and they do not allow you to set all data by SQL. Exactly, you can not set all those settings in configuration icon.
Additional problem can be solved by modifying you SQL query. You can see some examples on: demo.tramin.artio.cz/joomla25/components...mentation/useSql.php

SELECT '', 'category_name' UNION SELECT ...

I think, there is possible some solution to load data dynamically from database. (e.g. preset options for every row). I created task in our project management for this problem. But it may take long time to release it.

If you need this solution fast, you can contact our paid custom support on This e-mail address is being protected from spambots. You need JavaScript enabled to view it (copy to This e-mail address is being protected from spambots. You need JavaScript enabled to view it ). There you can consult details.

Your remark about UNION helped a lot to solve the second problem.

SELECT '','Total Time','Relative
Pref. Index','Disk I/O','MPEG2-DVD','H.264-BR'
UNION
(SELECT name, ideal, idealrpi, disk, mpeg, h264 FROM Percentiles LIMIT 0, 5)
UNION
(SELECT Computer_ID, total_time, crpi, Diskio, dvd, h264 FROM Personal_data WHERE Version LIKE 6.0 AND nr=36)

gives me the correct results in the table. I still have to figure out how to make the 'nr=36' condition in the last SELECT statement dynamic, to be used with fabrik links as a kind of 'Detail View', but the most pressing problem now is that updating the SQL query resets all my dataset preferences to a default that I do not want.

I want my datasets to look like this: ppbm7.com/index.php/results?showall=&start=5

Type, colours, line thickness, anchor radius, anchor angles, values, etc. are all changed after updating the SQL query to some default settings that make it - for my use at least - unworkable.

I need to be able to use real time SQL queries to update charts on-line but keep the layout I have once made. How can I set the defaults to these settings?

Hello,

this functionality is not implemented. You can try to modify component code, but then we can not guarantee correct functionality of the component.
There is only default settings for colors:
administrator/components/com_artiofusioncharts/helpers/helper.php - function getColorsPoll() - line 905

Upon saving a chart, the XML code generated is stored in a database table, __ARTIOFusioCarts or something simliar. Which component generates this XML code, because that module may be modified to retain my settings for the display, even though the data change.