Help With A Greenfield Card

[bringle]

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.

 

[jenna]

@Puckpsyd ???

 

[Puckpsyd]

This is quite challenging. With the right access, I could test whether or not a card with the information you seek could be made. But since fulfillment location_id metrics are restricted, it would be challenging, nay impossible, for me to validate whether any calculated fields that do what you want worked. For lo, I am but a humble store employee. Though I am trained in management information systems, Target HQ desires me not.


That being said, if you want to privately share with me the work you've done via DM, I could take a stab at it. Greenfield is kind of my jam.

 

[Puckpsyd]

You can go here to read more information on calculated fields in Greenfield. It's a very useful website. Target Auth Services - https://greenfielddocsite.target.com/

 

[Puckpsyd]

Good news, I was able to figure out how to create row numbers. Add this calculated field to your card. Be sure to sort your picked units in descending order.

'summarize(row_number(sum('pk_inf_pick_q') from 'FlexFulfillment.STORE_PICKUP_INF_SMRY'))'

EDIT: For your second option, I think you're better off exporting to CSV, and then copying and pasting into a pre-fabricated excel spreadsheet you have setup to give you the information you want. This may seem tedious. But it is possible to automate. I created two automations myself, that scrape Greenfield and download that information on to my computer.