2. PHPRunner General questions
  3. Cumulative 3D Charting - PHP 4.0 B2 -build 250
This topic is locked

Cumulative 3D Charting - PHP 4.0 B2 -build 250

 		5/12/2007 08:15:54
PHPRunner General questions
X
 xliner author

I tried to get the 3D charting to work that way, all data of a specific field is cumulatively flowing into one graph (bar, pie etc pp) only rather than to draw a graph for each record. I am sure, I missed to hook or click something here, any workaround ? Thx !
J
 		Jane 5/14/2007

Hi,
as I understand you need to edit your SQL query for this chart on the Edit SQL query tab.

Here are some helpful SQL tutorials:

http://webcheatsheet.com/sql/

http://www.w3schools.com/sql/default.asp
X
 		xliner author 5/14/2007

Jane,
many thx for teaching links, I´ll mail to "The MAK", editor of http://www.databasejournal.com/features/ms...10894_3373861_2 - Example 5 refers..., to kindly figure things out for me. If "The MAK" won´t work, I would need to go ahead with PHP Report Maker which I bought early February this year, okay, 2D only, but I can´t wait any longer on a certain project to be completed by now (if not to say, by yesterday...).
Hajo
Sergey Kornilov admin 5/14/2007

Hajo,
you can get much better and detailed help if you show a data sample.
What Jane is saying you need to use GROUP BY query combined with SUM() function.
Example:
select product, sum(qty) as sqty

from inventory

group by product
Use sqty as Data Series field, Product as Label.
X
 		xliner author 5/14/2007

Sergey,
thanx a million...
Hajo