4 Replies Latest reply on May 18, 2016 1:00 AM by David Heinz

    Average inventory by week

    Christophe Cluzel

      Hi,

       

      I have a challenge which I thought will be easy to solve but it seems that I am not as smart as I thoughts

       

      I am sure the solution will be simple to find for the bunch of expert around

       

      Here is the situation :

       

      I have all transaction (in and out of stock) for my parts since inception then I am able to calculate the inventory position at any point of time.

       

      But for an inventory dashboard I need to be able to calculate the inventory for any given period (usually month or week), the average inventory is defined by the following formula : (Inventory start period + Inventory end period)/2.

       

      This is then used to derive several KPI like service level....

       

      I attached a workbook with the example of 1 parts (we have 1000s in inventory) and the historical transaction by date. we do not have transaction every day for all the parts.

       

      Any help will be more than Welcome

       

      I am using Tableau 8.0

       

      Thanks in advance