Group in range problem

[Viktor]

Hello guys,

I have the following information that I should group by OrganizationalUnitCode, CurrencyDescription, ExecutiveCode and RecoveryDays.
The problem is that the last grouping RecoveryDays should be in range, for example 1 to 30 days, 31 to 60 days and etc. Is it possible to do this with Report.JS ?
[ {
"CurrencyDescription": "EURO",
"CustomerCode": "00100113764",
"ExecutiveCode": "exec1",
"ExecutiveName": "Executive1",
"InstallmentDate": "/Date(1425859200000+0000)/",
"InstallmentNumber": 2,
"InteresAmount": 0.05,
"LoanNumber": 83415,
"OrganizationalUnitCode": "001",
"OrganizationalUnitName": "TEST ORGANIZATION",
"PrincipalAmount": 1.67,
"RecoveryDays": 12,
"SavingAmount": 0,
"SolidarityGroupCode": null
}
]

I tried to group them in the following way - https://i.imgur.com/j61WYWu.jpg, but it's not working.
I also tried to remove Group4 and Group5 and put filters on the DataBands, but it looks like that the grouping by executive doesn't work then.

What is the best way to achive this grouping by range ?

[Alex K.]

Hello,

Unfortunately, in the JS version, there is not a simple solution for this task.
In your case, you should prepare a calculated values for grouping, for example - {Floor(Div(RecoveryDays-1,30))}

Thank you.