Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.