1 Reply Latest reply: Dec 28, 2016 11:37 PM by Praveen Prithiviraj

# divide month  4 weeks

Hi Community

may I could divide the month 4/5 weeks and every week at 7 days and represent data with a bar chart

Example

Month: December

I week: from 01/12 to 03/12

01/12 Tue

02/12 Fri

II week: from 4/12 to 10/12

.....

III week: from 11/12 to 17/12

....

IV week: from 18/12 to 24/12

...

V week: from 25/12 to 31/12

so that I represent

x bar: weekdays

y bar: count(Number of ticket)

I group data for week (I week) and represent the values for day of the week

x

x           x

x           x

x           x           x

x           x           x

x 10      x 24      x  35    x 2             55       2          44

--------------------------------------------------

lun      mar      mer      gio           ven      sab      dom (weekdays)

• ###### Re: divide month  4 weeks

Hi,

You can try this

if(month(weekend(date))= month(date),div(day(WeekEnd(date)),7),div(day(Weekend(date,-1)),7)+1)+1

Note: In "date", you need to mention the column name which you giving input date

I hope the below link will helpful to you...

Monthly week number !