Hi, for a food quality survey in a public school, I am trying to use stacked bar diagrams in a report widget to represent the outcome of a matrix question asking the kids to rate the food quality in various categories taste - look - size.
Unfortunately – and differently from the way excel does it by default – the bars are grouped/stacked by the values of header ROW, in my case the user ratings (good-average-poor) of the matrix instead of those in the COLUMN (taste-look-size). To me this seems to be a bug, since that behaviour makes no sense for most questionnaires using matrixes, but I cannot find how to change this behavior (even though I looked into the sql data representing the widget).
Can anybody here think of a way (i.E. php hack) to achieve this?
(I opened a support ticket, but the reply was I had to wait for them to rewrite their code, or to use 3 separate diagrams to visualize the matrix, but both isn't viable in my case)
Here is my form:
http://eks.872kent.net/machform/view.php?id=11657
Here is what the widget for the matrix question prints out:
http://eks.872kent.net/current-result.jpg
Here is what it SHOULD look like:
http://eks.872kent.net/desired-result.jpg