Current Grade-Previous Grade

[#1]

Hi experts,

Can any one please let me know how to accomplish my requirement..

each employee is given a grade (from 1 to 12), I need to show the % change in grade by month in bar graph.

(count of employeess from current grade-

count of employeess from previous grade)/count of employeess from previous grade

any help is highly appreciated..

[sushil353]

can u upload sample data

[neha_shirsath]

Hi,

Try this expression-

For  Current Grade:

Count({<Grade= {$(=max(Grade))}>}Employee)

For Previous Grade:

Count({<Grade= {$(= max(Grade-1))}>}Employee)

Hope it will help you.

Regards,

Neha

[udit_kumar_sana]

Hi,

Here you can try like this for month wise % change:

(count({<month>}emloyess current grade)-count({<month>}emloyess previous grade))/count({<month>}emloyess previous grade)

Regards,

Udit

[#5]

Hi Neha,

Thanks for the response.

The previous grade can be any grade need not -1

[#6]

Hi Udit,

thanks for the response I don't have any column that identifies it is current grade and previous grade

[udit_kumar_sana]

Hey,

You can try like this also,

create two alternate states as grp1 & grp2 by going in Document properties,in General tab you have alternate state option.

Create two list boxes of grades,one with grp1 state & other with grp2 state by assiging include exclude value in search option with this grp1 & grp2 states .

Know you can compare the grades with each other from this two list boxes.

Write the below expression in chart for % change month wise .

=

(count({<grp1,month>}emloyess current grade)-count({<grp2,month>}emloyess previous grade))/count({<grp2,month>}emloyess previous grade)

Regards,

Udit

[udit_kumar_sana]

Hey,

One change ,in list boxes assign states in alternate search field provided not in include exclude value option.

Regards,

Udit