New Group -> Week Interval - change start day

Hi, 
 
I'm wondering how you change the day the Week interval starts in the New Group screen? Instead of the default I would like my week to be Monday through Sunday. 
 
I tried to put a date which is a Monday in the "Fixed Base Value" but that didn't seem to have any effect. 
 
I found this posting: 
<a class='bbc_url' href='http://www.birt-exchange.org/forum/eclipse-birt-newsgroup-mirror/12676-how-define-first-day-week-when-using-weekly-interval.html'>http://www.birt-exchange.org/forum/eclipse-birt-newsgroup-mirror/12676-how-define-first-day-week-when-using-weekly-interval.html</a> 
 
I think it might be for a different problem though. 
 
Any help is appreciated. 
 
Thanks, 
 
Al

Find more posts tagged with

Comments

mwilliams

Hi Al,

Are you talking about the ordering of groupings in a table?

al91206

When you setup a group - and choose interval --> week - the week by default starts on <day> but I want it to be <different day>.

I've attached a screenshot. How do I change the day the week is calculated on.

Thanks!

Al

mwilliams

Al,

So, you're talking about the day of week of the week grouping starting on another day? Not just the day of week grouping being ordered how you want it?

al91206

That is exactly what I am looking to do - is it possible?

Thanks,

Al

mwilliams

Al,

I don't know of a way in which you'll be able to change which day the week starts on. One thing you could do would be to create your own "week of year" computed column and group on that. Your logic in creating the value for week of year could start on a certain day.

Hope this helps.

Adel Resto

Hi,

I have the same requirement (make the week grouping start on a different day). Were you able to find a solution for that?

Regards,

Adel

mwilliams

You'll probably have to create a computed column in your dataSet to change these. I've not seen a setting for it.

Adel Resto

Dear Mr. Williams,

Can you please give me some broad guidelines on your proposed idea? Let's say I want my week to start on Wednesday, the computed column will round the date field to the closest Wednesday?

Regards,

mwilliams

What you would do is you'd have to create a computed column for the week of year and for the day of week. If you wanted Wed as the first day, you'd find if the day of week was Sun, Mon, or Tues and you'd subtract 1 from the week of year. Then, in the day of week column, you'd adjust the day of week to be the correct value for what you're wanting. Then, you'd have your values for the groupings.

If you were just wanting Monday, there is a BIRT function that can be used for weekDay that has an optional parameter to set the start day to Monday.

vijayshankar245

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="111692" data-time="1353436597">
<div>
What you would do is you'd have to create a computed column for the week of year and for the day of week. If you wanted Wed as the first day, you'd find if the day of week was Sun, Mon, or Tues and you'd subtract 1 from the week of year. Then, in the day of week column, you'd adjust the day of week to be the correct value for what you're wanting. Then, you'd have your values for the groupings. If you were just wanting Monday, there is a BIRT function that can be used for weekDay that has an optional parameter to set the start day to Monday.
</div>
</blockquote>
 Thanks mwilliams can i have one sample code for the above example