Is it possible in Jaspersoft reports server to group dates by week?

0

Hi there, 

Im in the middle of creating a report using an ad hoc. However when it comes to grouping our data, we need to do this by week. Is this possiable or will need to look into a diffreant way of creating our report?

Cheers

 

timy2's picture
7
Joined: May 10 2013 - 4:02am
Last seen: 5 years 11 months ago

3 Answers:

0

Hi,

While creating adhoc report you can add sql query in the domain. So use a query with group by week in domain.

which database you are using ?

 

Thanks'

Ajinkya.

 

ajinkya_c's picture
976
Joined: Aug 29 2012 - 6:13am
Last seen: 2 years 5 months ago
0

Hi Ajinkya,

Thats good to know, im using amazon redshift to store my data and connecting through that.

Cheers

timy2's picture
7
Joined: May 10 2013 - 4:02am
Last seen: 5 years 11 months ago
1

You can also use calculated fields in the domain to extract the week of the year from the date field and expose that as a field. You can read more about calculated fields in Chapter 6 of the Japser Server User guide ( http://community.jaspersoft.com/documentation ) and also in the JRS Ultimate Guide

marianol's picture
4575
Joined: Sep 13 2011 - 8:04am
Last seen: 10 months 3 weeks ago
Feedback
randomness