Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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...