This topic is locked

Detailed Charts

7/1/2007 5:15:58 PM
ASPRunnerPro General questions
M
minnydiva author

Hi,
Is the Chart and Reports system quite basic or can you create detailed reports.
I have done a search on Charts and not much came up from this forum.
As an example what I am aiming to achieve is to create a pie chart on car milage between the values 0-10,000 miles, 10,001-15,000 miles, 15,001-20,000 and so on. I would like to create a percentage from all the people who own cars on our database between the mileage above. For instance I would like to the show the percentage of people who have done 0-10,000miles and so on.
Hope I have explained myself correctly if not please let me know.
Is what I am asking possible?
Many thanks

Sharron <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=5671&image=1&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' />

Sergey Kornilov admin 7/2/2007

Sharron,
this is possible however you need to shape your data first.

I believe you need to modify the SQL query in ASPRunnerPro using GROUP BY clause.