Hi Jazz Team,

I am trying to create a graph showing work items per week over the last 1 month using IBM Jazz Reporting Service.I am using RTC 5.0.2 server.
I realized that grouping data in results is possible only by the drop down in the preview section on top , thus we can group only by columns available in that drop down.
But if I want to do group by Work item creation month  by editing query in query editor under Advanced tab I get the error

CRRGW5628E An com.foundationdb.sql.parser.SQLParserException error occurred when validating the input SQL string, caused by Encountered " "group" "GROUP "" at line 13, column 1. Was expecting one of: "fetch" ... "for" ... "with" ... "offset" ... "limit" ... "," ... ";" ... .

Is there any limitation that one can`t use group by clause in query editor here?