Hi, I am currently evaluating phpRunner and am having a problem with Charts.
I have a data similar to this one and am using a similar select statement:
SELECT species, sex, COUNT() FROM pet GROUP BY species, sex;
+---------+------+----------+
| species | sex | COUNT() |
+---------+------+----------+
| bird | NULL | 1 |
| bird | f | 1 |
| cat | f | 1 |
| cat | m | 1 |
| dog | f | 1 |
| dog | m | 2 |
| hamster | f | 1 |
| snake | m | 1 |
what I expect to be able to do in charts is generate a chart with Species as a label, then as my data series, I should have access to : the number of females, number of males and number of nulls for each species.
From that I should be able to create a stacked chart (like the 2d stacked column) with Species along the bottom. and a stack (numbered above each species showing totals for each sex associated with same species.
But instead, I get only count(*) as a data series choice, and I can pick either sex or species as my label. The resulting chart is meaningless as it contains :
Bird: total 1
Bird: total 1
Cat: total 1 etc, but no way to tell what it is a total of (that it is e.g. total 1 female).
It is as though the grouped sub-totals are not recognised.
I'm new to this, just checking if the product meets our needs, so apologies for the long question. Am I doing something silly (I hope so!), or is this a bug/serious limitation?
All help and advice much appreciated.
Brilliant product, by the way!
Version 4.0 (build 265) Evaluation
