divide month 4 weeks

[fmazzarelli]

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)

[praveen_prithiviraj]

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 !