Forum Discussion

CaptRon's avatar
CaptRon
New Member
4 years ago
Solved

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 metri...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

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.