Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
I have no clue what you mean
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.
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.
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 |
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.
Does this look right?
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 |
Not sure what you mean... I am going to request you to update the qvw to show me the error point... Thank you!!
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 |