6 Replies Latest reply on Oct 7, 2018 7:26 PM by Xu Han

Calculation using FIX

Hi Guys,

Would deeply appreciate is anyone may help in below calculation. Basically I would like to calculate staff productivity in term of picking lines per min. I need this metric in 4 different levels:

1. Overall (eg. by day)

2. Wave (eg. this is like picking batch);

3. Staff Level

4. Wave+Staff Level

Sample data is like below:

 Wave Line Picker Pick Time 001 111 A 28/9/2018 17:46 001 112 A 28/9/2018 17:49 001 113 A 28/9/2018 17:49 001 114 A 28/9/2018 17:50 001 115 B 28/9/2018 17:51 001 116 B 28/9/2018 17:53 001 117 B 28/9/2018 17:54 001 118 A 28/9/2018 17:55 002 121 A 28/9/2018 17:45 002 122 A 28/9/2018 17:50 002 123 C 28/9/2018 17:53 002 124 C 28/9/2018 17:56 002 125 C 28/9/2018 17:58 003 131 A 28/9/2018 17:43 003 132 A 28/9/2018 17:49 003 133 B 28/9/2018 17:51 003 134 B 28/9/2018 17:54 003 135 C 28/9/2018 17:55 003 136 A 28/9/2018 17:57 003 137 A 28/9/2018 17:58

I manage to work out { FIXED [Wave]:min([Pick Time])}, { FIXED [Wave]:max([Pick Time])} for my wave time. I then calculate line per min using ([Num_Lines]-COUNTD([Wave]))/SUM([Wave Time]). Reason for subtracting countd(wave) was to deduct first line in each wave

My overall in 28 Sep is 0.46 line per min seems correct, verified by (8+5+7-3)/(9+13+15)=0.46; And by wave level also seem to be correct, eg. (8-1)/9=0.78

I took a similar approach for #3 & 4 calculation that involve in staff. I manage to get min and max by staff in each wave, using { FIXED [Wave],[Picker]:min([Pick Time])}.

However, my end calculation calculation of line/min is wrong. Example Staff A wave 002, Line/Min should be (2-1)/5=0.2

What I need:

3. Staff Level

A/B/C Line/per Min

4. Wave+Staff Level

eg. A/001 Line per min, A/002 Line per min.

Attached a workbook in version 10.5

Thank you...

• 1. Re: Calculation using FIX

HI Xu Han

ot exactly sure but I tried to create each layer of LOD.

************** wave + staff

*********** Staff

Thanks,

Shin

1 of 1 people found this helpful
• 2. Re: Calculation using FIX

Seems like I was quite close

Thank you!

• 3. Re: Calculation using FIX

Hi Xu Han

You are very welcome.

Shin

• 4. Re: Calculation using FIX

Hi Shin,

Sorry I encountered another issue when applying this to my real data. My data consist of multiple days, when apply staff max and staff min, it would retrieve the oldest historical timestamp. How to limit staff min to today's min performed by staff.

• 5. Re: Calculation using FIX

Please attach mocked up workbook which replicates errors.

Shin

• 6. Re: Calculation using FIX

Hi Shin,

Please see attached workbook.

As you can see below, I added another wave happened on 25 Sep. The staff min took that as the staff min however I would like tableau to calculate based on daily min, not historical min. The ideal solution would be able to calculate picker's line/min by day, otherwise, knowing their most recent day's performance would suffice.

Many thanks...