Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have some given date ranges starting from January to March 15th. I would like to display these dates in bi-weekly in a Bar chart. Can you please help me out. Thanks.
Hi
Try like below
Date(DateField) as DateField,
Week(DateField) as WK,
'BIWK' & Ceil(Week(DateField)/2) as BIWK
Use BIWK in the bar chart
you can try one of the below logic:
Date(2+14*Div(create_date-2,14)) as BiweekStart
Date(Floor(Date,14,2)) as BiWeekDate
dual(text(weekstart(Date)),div(weekstart(Date),14)) as BiWeekDate,