Hello,
I am in the process of making a Greenfield card that ranks TM's across all stores by the amount of units they've picked. I've used the FLEX_INF_OVERVIEW dataset to achieve this, but a couple things are missing. Firstly, I haven't figured out a way to make a static numbering column that simply displays what number each column is in order. This would help identify what exact rank each TM is in without having to manually count. Secondly, I want to add a new column that would divide the amount picked by the amount their location has picked in total. This figure I hope would put TM's who work at a store that doesn't have as much volume as others on a even playing field. The problem is however, I could only find that information on (Assets_Protection_EDABI.ap_tm_pick_productivity). Greenfield themselves state that cross-referencing datasets is not recommended but I'm still holding out faith that its possible. Merging datasets don't appear to be an option either since I'm not a Greenfield technician. I can't seem to find much accessible documentation on calculated fields, but I hope someone with more experience can help me achieve this. If we could get this working then maybe I could implement further metrics like batches, pickrate, or even time spent to give a better idea of who is actually a top performer. I'm going for a stathead kind of approach with this card. Any help would be appreciated.
Thank you.
I am in the process of making a Greenfield card that ranks TM's across all stores by the amount of units they've picked. I've used the FLEX_INF_OVERVIEW dataset to achieve this, but a couple things are missing. Firstly, I haven't figured out a way to make a static numbering column that simply displays what number each column is in order. This would help identify what exact rank each TM is in without having to manually count. Secondly, I want to add a new column that would divide the amount picked by the amount their location has picked in total. This figure I hope would put TM's who work at a store that doesn't have as much volume as others on a even playing field. The problem is however, I could only find that information on (Assets_Protection_EDABI.ap_tm_pick_productivity). Greenfield themselves state that cross-referencing datasets is not recommended but I'm still holding out faith that its possible. Merging datasets don't appear to be an option either since I'm not a Greenfield technician. I can't seem to find much accessible documentation on calculated fields, but I hope someone with more experience can help me achieve this. If we could get this working then maybe I could implement further metrics like batches, pickrate, or even time spent to give a better idea of who is actually a top performer. I'm going for a stathead kind of approach with this card. Any help would be appreciated.
Thank you.
