Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have one requirement creating week buckets on one field.
What exactly i want is I have one field like DOJ.i wanted to create On that field week buckets i.e in one month we have max 4 or 5 weeks it consist like wise i want week buckets for enataire Year and i should show on line chart.Kindly help me on this with your vallid solutions.
Here i m sharing Sample Data also.
Its Urgent>>>>>>>>
yeah you can make it further like below
if(match(Day(DOJ),1,2,3,4,5,6,7),'Week1',
if(match(Day(DOJ),8,9,10,11,12,13,14),'Week2',
if(match(Day(DOJ),15,16,17,18,19,20,21),'Week3',
if(if(match(Day(DOJ),22,23,24,25,26,27,28),'Week4','Week5'))) ) as Week
hey try this
Load *,
if(match(Day(DOJ),1,2,3,4,5,6,7),'Week1',
if(match(Day(DOJ),8,9,10,11,12,13,14),'Week2',
if(match(Day(DOJ),15,16,17,18,19,20,21),'Week3','Week4'))) as Week
from Emp.xls
Week(DOJ) as Week
Or
WeekName(DOJ) as WeekName
=WeekYear(Today()) &'-'& NUM(Week(Today()) ,'00')
Use DOJ instead of Today()
Hi Prem,
As per your solution,
Week1>> 1-7,
Week2>> 8-14,
Week3>>14-21,
Week4>> 22-28,
Week5>> ??
Week5>> 29-31 Should be also there right.
Why because some months consist 30 ans some 31.
Any one help me on this...
yeah you can make it further like below
if(match(Day(DOJ),1,2,3,4,5,6,7),'Week1',
if(match(Day(DOJ),8,9,10,11,12,13,14),'Week2',
if(match(Day(DOJ),15,16,17,18,19,20,21),'Week3',
if(if(match(Day(DOJ),22,23,24,25,26,27,28),'Week4','Week5'))) ) as Week
Let me creak whether its fulfilling my requirement or not ?
Can we create in Front End ?
Let me know.