Calculate the Chart expression value based on input value

[poluvidyasagar]

Hi all,

I am trying to calculate productivity of the manpower based on shift using bar chart. However, i would like use to input box to input the number of people in each shift.

Example:

Data: 

Part	Shift	Event
A	1	Finished
B	1	Finished
C	1	Finished
D	1	Finished
E	2	Finished
F	2	Finished
G	2	Finished
H	2	Finished
I	2	Finished
J	2	Finished

Input Box Variables:

Variables	Variable Value
Number of 1st shift people	5
Number of 2nd shift people	3

So,

Productivity of 1st shift people based on finished event time = 3/5 (number of finished events/number of people in 1st shift)

Productivity of 2nd shift people based on finished event time = 5/3 (number of finished events/number of people in 1st shift)

How do i calcuate this in expression because my number of people in shift changes everyday.

Thanks,

Vidya

[vishsaggi]

Try this?

Add Dim:

Date

Shift

Expr:

= Pick(Shift, Count({< Event = {'Finished'}>} Part)/$(vShift1People),
                    Count({< Event = {'Finished'}>} Part)/$(vShift2People))

[vishsaggi]

Did you get what you are looking for?