Finding the Previous and current rating

[Anonymous]

Load * Inline [

AppraisalPeriodToDate,Rating,ID,Employeename

4/31/2016,7,2,yoga

5/28/2016,7,2,yoga

6/31/2016,8,2,yoga

7/30/2016,6,2,yoga

8/31/2016,7,2,yoga

9/30/2016,5,2,yoga

10/31/2016,7,2,yoga

11/28/2016,7,2,yoga

12/30/2016,8,2,yoga

1/30/2017,6,2,yoga

2/28/2017,7,2,yoga

3/31/2017,10,2,yoga

1/31/2017,7,1,Vijay

2/28/2017,7,1,Vijay

3/31/2017,8,1,Vijay

4/30/2017,6,1,Vijay

5/31/2017,7,1,Vijay

6/30/2017,5,1,Vijay

7/31/2017,7,1,Vijay

8/28/2017,7,1,Vijay

9/30/2017,8,1,Vijay

10/30/2017,6,1,Vijay

11/30/2017,7,1,Vijay

12/30/2017,10,1,Vijay

];

i have data like this now  I have scenarios where I will have many no.of AppraisalDates(AppraisalStartDate,AppraisalEndDate) and I want to calculate the  Final Rating by adding up for last 6 months(AppraisalEndDate: 7/12/2017-12/30/2017) as Current Rating and previous 6 months(AppraisalEndDate: 1/31/2017-6/30/2017) as Previous Rating. if an employee starts the appraisal date from April(4/30/2016) to March(3/30/2017) how it will change dynamically  and  i want show  first 6 month as  previous rating and next 6 months as current rating the chart should be display like this

   Can anyone help me out to how we can do that?

[ramasaisaksoft]

Check the below one.

i think you need to create 2 expressions for 1- 6 months,7-12 months and for Employee dimension.

Bar chart--> style should be vertical

first expression = if(appraisal start date>='1jan2016' and appraisal start date>='30jun2016',appraisal rating)

second expression= if(appraisal End date>='1july2016' and appraisal start date>='31dec2016',appraisal rating)

i am not sure how much % of solution i give properly to ur query.please share some sample data and required out put data so that our folks will help to you more than me.