Material Creation

Hello,

I’m looking to implement a single KPI to show when a material (connected to a PO) was ordered and how often it was ordered within a specified timeline.
Can anyone provide guidance on this?

Best,
Hormoz

Hi Hormoz,

an approach to check when a material was ordered could be to filter on the activity ‘Create Purchase Order Item’ in the activity table. You can then use the EVENTTIME to check when this specific material was ordered and COUNT the EVENTTIMES to calculate how often it was ordered. To limit the KPI to a specific timeframe, I would recommend using either a component filter or CASE WHEN statement in the COUNT function.

Best,
Viana

Thank you Viana, this helps!