I am trying to graph out a call center metric for students 6wks prior to training and 6wks after they took training in 1 week intervals.
There are hundreds of students that took the training over a long period of time therefore the before and after is not a single date in time.
I do not have two date fields to compare, therefore i'm converting both to weeks.
- WEEKOFYEAR(`Offering End Date`) -- gives me the actual week of the year vs. fiscal / last day of training
- **I think i need to subtract 30 from this to match the fiscal week? - Our fiscal wk 1 is Feb 1st.
- RIGHT(`Dim - CalendarFiscal Week`,2)*1 -- gives me the fiscal week of call center measurement
I've attached a picture of what the graph looks like now using the SPC graph.
I want to do three things now:
- Have the 'before' line -6 through 0 be one color
- Have the 'after' line 1 through 6 a different color
- Create a summary number showing the difference between the two so you can see if it increased after training
Can someone help me figure out how to achieve this?
case when WEEKOFYEAR(`Offering End Date`) = RIGHT(`Dim - CalendarFiscal Week`,2)*1 then '0Wk'
when WEEKOFYEAR(`Offering End Date`) - RIGHT(`Dim - CalendarFiscal Week`,2)*1 = '1' then '-1wk'
when WEEKOFYEAR(`Offering End Date`) - RIGHT(`Dim - CalendarFiscal Week`,2)*1 = '2' then '-2Wk'
when WEEKOFYEAR(`Offering End Date`) - RIGHT(`Dim - CalendarFiscal Week`,2)*1 = '3' then '-3Wk'
when WEEKOFYEAR(`Offering End Date`) - RIGHT(`Dim - CalendarFiscal Week`,2)*1 = '4' then '-4Wk'
when WEEKOFYEAR(`Offering End Date`) - RIGHT(`Dim - CalendarFiscal Week`,2)*1 = '5' then '-5Wk'
when WEEKOFYEAR(`Offering End Date`) - RIGHT(`Dim - CalendarFiscal Week`,2)*1= '6' then '-6Wk'
when WEEKOFYEAR(`Offering End Date`) - RIGHT(`Dim - CalendarFiscal Week`,2)*1 = '-1' then '1wk'
when WEEKOFYEAR(`Offering End Date`) - RIGHT(`Dim - CalendarFiscal Week`,2)*1 = '-2' then '2Wk'
when WEEKOFYEAR(`Offering End Date`) - RIGHT(`Dim - CalendarFiscal Week`,2)*1 = '-3' then '3Wk'
when WEEKOFYEAR(`Offering End Date`) - RIGHT(`Dim - CalendarFiscal Week`,2)*1 = '-4' then '4Wk'
when WEEKOFYEAR(`Offering End Date`) - RIGHT(`Dim - CalendarFiscal Week`,2)*1 = '-5' then '5Wk'
when WEEKOFYEAR(`Offering End Date`) - RIGHT(`Dim - CalendarFiscal Week`,2)*1= '-6' then '6Wk'
else 'null' end