2. PHPRunner General questions
  3. Ranges in Chart
This topic is locked

Ranges in Chart

 		10/13/2010 7:05:34 PM
PHPRunner General questions
J
 jmyersnc author

I am trying to create a chart to display ranges
My ranges are like this:

0 - 149,999

150,000 - 199,999

200,000 - 299,999

300,000 - 399,999

400,000 - 499,999

500,000 - 599,999

600,000 - 699,999

700,000 - 799,999

800,000 - 899,999

900,000 - 999,999

1,000,000 - 1,249,999

1,250,000 - 1,499,999

1,500,000 +
The other axis will be count for those ranges.
My table name is soldre and the field for the price is SoldPrice
Thanks for the help
Sergey Kornilov admin 10/13/2010

I kind of miss the question here.
J
 		jmyersnc author 10/13/2010



I kind of miss the question here.


I am trying to create a chart using phprunner. On axis, I want the groups listed above and on the other axis will be the total count for that range.
0 - 149,999

SELECT COUNT( * )

FROM soldre

WHERE SoldPrice

BETWEEN 0

AND 149999
If the total count was 150, then on the X axis will be my ranges then on the Y axis will be the total count, make since now?
Sergey Kornilov admin 10/14/2010

The only question I see here is "make since now?". I don't get what exactly you having problem with.
Probably it makes sense to contact support directly sending your database along with sample chart you trying to build.