Is it possible to group a report by 15 min?

This topic is locked

Is it possible to group a report by 15 min?	4/10/2009 6:23:43 AM
PHPRunner General questions
hichem author I was wondering if it was possible to set the number of minutes or hours to use in the report grouping. Currently in PHPR 5, you can only group by ..,week, day,hour, minute. Would be great it it was possible to put a unit in front of each one selected so I could group by 5 or 15 minutes. Is there a workaround to do this or may be planned for the future? I can generate a view and custom sql to group by anything I like but wouldn't get the nice formating as available for reports. Thanks Hich


J	Jane 4/10/2009
	Hi, you can edit SQL query on the Edit SQL query tab and create new field (two days for example) and then use this field as Group field on the Reports: Group fields tab. Unfortunately there no way to set up it in the PHPRunner directly.