Hi All,
What is the best optimised options to display the date labels with bi-weekly intervals starting date Date from one month to three months future from the current date?
As per above requirements, I have built the below line graph query and graph, currently it only displays the date labels as per data but I need to display date labels with bi-weekly intervals starting date from one month to three months future from the current date. Also another issue found, if there are few more date labels then does not show all labels on horizontal axis.
Select
/* Set Week End date as Sunday */
DATEADD(DAY, 7 - DATEPART(WEEKDAY, t.TaskBaseline0FinishDate), CAST(t.TaskBaseline0FinishDate +1 AS DATE)) as[WeekEnd]
,count(t.TaskBaseline0FinishDate) as Baseline
,count(t.TaskFinishDate) as Finish
from
MSP_Task_UserView t INNER JOIN MSP_Project_UserView p on p.ProjectUID=t.ProjectUID
Where 1=1
AND t.ProjectUID='5D3285EE-B699-4718-B85D-53DD14A37DE5'
Group by DATEADD(DAY, 7 - DATEPART(WEEKDAY,
t.TaskBaseline0FinishDate), CAST(t.TaskBaseline0FinishDate
+1 AS DATE))
Order by DATEADD(DAY, 7 - DATEPART(WEEKDAY,
t.TaskBaseline0FinishDate), CAST(t.TaskBaseline0FinishDate+1 AS DATE))
Thanks in advance for your help.