Question on Pivot Table % Calculation

[gopikrishnach]

I want to create a Dashboard with Monthly % calculation by task, By monthwise and Yearwise based on Task Completion Time. I Created a Piovt Table with my data, but the % values are not coming correctly.

Here iam attaching the datewise date, based upon data we need to calculate the Monthwise reload completion  % and yearwise reload completion % Value.

Please help me how to calculate the % calculation by Monthly and yearly for each task.

[gopikrishnach]

Yes correct, But mapping will not happen due to those are standard formats. So we need to change the expression, based upon the Task name.

[sunny_talwar]

I have no clue what you mean

[gopikrishnach]

In that expression we are maping timing based upon numeric, but I have different SLA Timing for each and individual tasks. Like 1_ADR_finals SLA IS 23:00, 1_SAL_QVD task SLA is 5:00. So I need expression based on task name not as per the numeric.

[sunny_talwar]

You need a different SLA Time for each of the task, right? So where is that list? If you are unable to answer my direct question this time... I apologize in advance for not responding after this... Because I am trying my best to help you... but you are just not giving me enough to help you.

[gopikrishnach]

Find below is the SLA timings for each task.

Task Name	SLA Timings
1_vd	21:30:00
1_CURR	1:30:00
1_ADR_finals	21:35:00
1_ADR_prelims	5:15:00
1_DC_QVD Extract	21:00:00
1_CLASS QVD Extract	21:35:00
1_BRDG_QVD_Extract	5:10:00
1_SAL_QVD_Extract	5:10:00
1_QVD_Final	21:40:00
1_QUOT_Daily	3:30:00
1_User_Pro	2:35:00
2_TVD	9:25:00
2_Tvfb	21:50:00
3_APPBD	6:08:00
3_APPBD_Trans	23:00:00
4_APBD	6:03:31

[gopikrishnach]

Yes I have different SLA for each task, some of the task will complete Yestesday(i.e., Current date-1) and some of the task on same day. 4_ task is dependent on 3_; 3_ task dependent on 2_; 2_ dependent on 1_. For each app we have multiple 1_,2_ and 3_ task. So based upon SLA timings we need to calculate the Monthly and Year FLAG. Please help me, how to calculate the SLA % by Month wise. Thank you so much for your help.

[sunny_talwar]

Does this look right?

[gopikrishnach]

In below situation it is not working, due to some of the task were completed yesterday(Current Day-1).

please use the same Task Completion timings.

Task Name	SLA Timings
1_Eds	5:00
1_PER_QVD Extract	5:00
1_HRCHY finals	5:00
1_HRCHY prelims	5:00
1_DDC_QVD Extract	5:00
1_PROD	5:00
1_STO	5:00
1_BAL	5:00
1_VFBAL	5:00
1_QUOTA	5:00
1_PROJECTIONS	5:00
2_FVD EXTRACT	5:00
2_VFBAL EXTRACT	5:00
3_VFBAL TRANSFORM	5:15
4_VFBAL	5:30

[sunny_talwar]

Not sure what you mean... I am going to request you to update the qvw to show me the error point... Thank you!!

[gopikrishnach]

Please refer below screen shot and mentioned different SLA timings.

Task Name	SLA Timings
1_vd	5:00:00
1_CURR	5:00:00
1_ADR_finals	5:00:00
1_ADR_prelims	5:00:00
1_DC_QVD Extract	5:00:00
1_CLASS QVD Extract	5:00:00
1_BRDG_QVD_Extract	5:00:00
1_SAL_QVD_Extract	5:00:00
1_QVD_Final	5:00:00
1_QUOT_Daily	5:00:00
1_User_Pro	5:00:00
2_TVD	5:00:00
2_Tvfb	5:00:00
3_APPBD	5:15:00
3_APPBD_Trans	5:15:00
4_APBD	5:30:00