Jump to content
Changes to the Jaspersoft community edition download ×

Concurrent Groups


2004 IR Help

Recommended Posts

By: Daniel Ruoso - ruoso

Concurrent Groups

2005-07-13 11:37

Hi,

 

I am trying to design a revenue report, and I want to group it both by month and by week, but I don't want the week to be resetted if the month changes in the middle of the week.

 

i.e:

 

Revenue Report

 

Month A

Week 1

sunday

monday

tuesday

wednesday

thursday

friday

saturday

Total for Week 1: XYZ

Week 2

sunday

monday

tuesday

Total for Month A: XYZ

Month B:

wednesday

thursday

friday

saturday

Total For Week 2: XYZ

 

 

Something like that...

 

any ideas?

 

 

 

 

By: C-Box - c-box

RE: Concurrent Groups

2005-07-13 12:48

Make a method that returns the weeknumber by a given date.... so you could group by this weeknumber and the second group is by month.... not tried but should work. The Incrementer should of course increment the sum by weeknumber and month separately... so don't think that you will have resetted values if the month is starting at the middle of a week. Not tried but interesting for me also.

 

just try it and post if (and how) it works

C-Box

 

 

 

 

By: Daniel Ruoso - ruoso

RE: Concurrent Groups

2005-07-13 13:02

Hmmm...

 

I don't think I understand it...

 

Wouldn't this make the month to be resetted on week change?

 

 

 

 

By: Daniel Ruoso - ruoso

RE: Concurrent Groups

2005-07-19 13:35

Anynone has any idea? Or this feature simply doesn't exist?

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...