Confusion with Charts

This topic is locked

Confusion with Charts	5/2/2012 10:59:52 AM
PHPRunner General questions
A ant author Please can someone help me with Charts. I have gone through videos, manual and all the references I can find but I can't get the hang of setting up the charts with sql queries. I previously made a post "Adding filter items to Charts" but couldn't solve the problem. The charts are great tools for looking at the stats of my business and I am desperate to get the hang of it. I decided to use a simpler module and am using the cars template to try to recreate the same scenario. Aim of Chart: To Show 'YearofMake' on the X Axis and the Total Make of Cars on the Y Axis plus show how many of each Make of Car makes up the total. I have tried various filters and group but can't get it right. The best I can do is show the Make of car and number of cars on the Y axis. Below is a screen shot of the query, results and chart. [size="4"]QUERY[/size] [size="4"]SQL QUERY[/size] [size="4"]QUERY RESULTS[/size] [size="4"]CHART[/size]


	Sergey Kornilov admin 5/2/2012
	The missing link between your source data in the database and your chart is transformed data, the result of SQL query. You need to understand what sort of data you want to get as a result you can build the proper SQL Query or at least explain it the way someone can help you. I can also suggest to build the same chart in Excel for instance using the same source data. This way you can have a better understanding of what it takes to build the chart you looking for.