How can we show values for a date range,
My date range here is 2 weeks alternate Wednesday(07-09-2014, 07-23-2014), and I need to count number of documents submitted in that date range.
Output:
Project Name | Prjt Manager | Dates : 7/23/2014- 7/10/2014 | 7/9/2014-6/26/2014 | 6/25/2014-6/12/2014 | 6/11/2014-5/28/2014 |
Prj 1 | Sam | 5 | 3 | 2 | 1 |
Prj 2 | Pam | 1 | 2 | 1 | 2 |
Prj 3 | Dan | 2 | 4 | 5 | 3 |
Prj 4 | Don | 1 | 0 | 4 | 5 |
Script
Calendar:
Load
Calendar_Dt;
SQL Select Calendar_Dt,
Case When abs( year_week/2)<>floor( year_week/2) and DAY_ABBREVIATION='WED'
Then 1
ELSE 0
END as Flag
from DMN_CALENDAR
where CALENDAR_DT>=Sysdate - 365 and CALENDAR_DT<=Sysdate
and DAY_ABBREVIATION='WED' ;
Portfolio:
Load
Modified_Date as Calendar_Dt,
Project Name,
Prjt Manager,
Path
From
Portfolio.xlsx;