Forum Discussion
Creating calculated columns or measures for Warehouse Productivity Report
Hi All,
Looking for help with producing a warehouse productivity report based on the attached dataset. I am looking to create a dashboard that we can refresh weekly and populate the following metrics per day of that week. Total Cycle counts, Cycle count Avg per/HR, Total Putaways, Putaways avg per/hr, Total Receiving, Receiving avg per/hr, Total SO Picking, SO Picking avg per/hr, Total Work Order Picking, Work Order Picking avg per/hr. The challenges i am having are that all of the tasks are in one column how do i make them into there separate metrics? Calculated columns? Measures? Any help would be greatly appreciated. Thanks
| First Name | Last Name | User ID | Date & Time | Hour | Task | PSN | Branch | Full Name | Date |
| Employee | One | One | 1/1/2022 2:00:00PM | 14 | SO Picking | Employee One | 1/1/2022 | ||
| Employee | Two | Two | 1/2/2022 3:15:00PM | 15 | Putaway | Employee Two | 1/2/2022 | ||
| Employee | Three | Three | 1/3/2022 11:00:00AM | 11 | Cycle Counts | Employee Three | 1/3/2022 | ||
| Employee | Four | Four | 1/4/2022 11:30:00AM | 11 | Work Order Picking | Employee Four | 1/4/2022 | ||
| Employee | Five | Five | 1/5/2022 12:45:00PM | 12 | Receiving | Employee Five | 1/5/2022 | ||
| Employee | One | One | 1/1/2022 2:00:00PM | 14 | SO Picking | Employee One | 1/1/2022 | ||
| Employee | Two | Two | 1/2/2022 3:15:00PM | 15 | Putaway | Employee Two | 1/2/2022 | ||
| Employee | Three | Three | 1/3/2022 11:00:00AM | 11 | Cycle Counts | Employee Three | 1/3/2022 | ||
| Employee | Four | Four | 1/4/2022 11:30:00AM | 11 | Work Order Picking | Employee Four | 1/4/2022 |
Hi, CaptRon ;
In fact, I don't think it is necessary to set a measure. If you want to display each type separately, you can set it in the filter criteria as follows. If you want to set Cycle Counts total and average value:
and averge.
the final show:
and so on.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
v-yalanwu-msftCommunity Support
Hi, CaptRon ;
In fact, I don't think it is necessary to set a measure. If you want to display each type separately, you can set it in the filter criteria as follows. If you want to set Cycle Counts total and average value:
and averge.
the final show:
and so on.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.This was really helpful thankyou!
