Hello,
I've got a question about charts...
In a chart, I use the method "Shaping your data more complex way" described in the online documentation : http://xlinesoft.com/phprunner/docs/using_sql_to_shape_chart_data.htm
I use a select which is similar to the one given and when I build my project and, when I try to visualize the chart, an error is displayed in the center of the area:
"XML Parser failure: The element type must be terminated by the matching eng-tag".
Here is the query I use (it works fine when used in the result tab of the "Query" Panel) :
SELECT distinct Table1.Day, a.RED,b.GREEN, c.BLUE FROM Table1
LEFT JOIN (SELECT SUM(NBItems) as RED, Day FROM Table1 WHERE ColID =8 AND Day LIKE "%00" GROUP BY Day) a ON Table1.Day=a.Day
LEFT JOIN (SELECT SUM(NBItems) as GREEN, Day FROM Table1 WHERE ColID =5 AND Day LIKE "%00" GROUP BY Day) b ON Table1.Day=b.Day
LEFT JOIN (SELECT SUM(NBItems) as BLUE, Day FROM Table1 WHERE ColID =1 AND Day LIKE "%00" GROUP BY Day) c ON Table1.Day=c.Day
WHERE Table1.Day LIKE ""
ORDER BY Table1.Day
Which returns a table like :
DAY, RED, GREEN, BLUE
20100100, 7, 9, 3
20100200, 6, null, 8
20100300, null, 2, 4
20100400, 5, 1, 4
...
I tried with a result-set avoiding null's, without success. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=13996&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
Any idea that could show me the way?
