2. PHPRunner General questions
  3. piviot table and chart
This topic is locked

piviot table and chart

 		6/14/2012 3:15:21 AM
PHPRunner General questions
R
 rstackhouse author

Back in 5.1 I understood charts would be updated to allow pivot (JOIN INNER) tables. I see it in reports so perhaps that's what I heard.
I have a table with items 1) minutes 2) week 3) group.... I can create a report using the "cross" command..

week1 week2 week3 week4

group1 M1 M2 M3 M4

group2 M5 (etc)

group3



where M1 is the sum of the minutes for group1 during week1
I would like to create a graph for this (probably a vertical bar chart)..
Is that possible, is there a "how do"? At first I thought I could create the report then cut and paste the mysql, but I see the cross is in another section past the query setup tab.
Sergey Kornilov admin 6/14/2012

Unfortunately you cannot create pivot charts. This option is only available for reports.
R
 		rstackhouse author 6/15/2012

Thanks for the definitive answer..
Do you have a prefered/suggested alternative that might be a good sister/brother product/provider to phprunner for mysql data visulization?