14 Replies Latest reply on Mar 28, 2013 1:34 PM by Sarah Gehrke

    Calculating Age and Count using Microsoft Project Data based on Conditions

    Sarah Gehrke

      Hello,

       

      I am trying to create the following data (top) so it can be displayed in a chart like this (bottom). The Colors in the graph would denote Activity. I have attached a sample data file.

      Table 4: Individuals in the Last Process by Activity

      Pending FRA Activity

      to be Completed

      Quantity

      of Individuals in each Activity

      Count of Individuals who have spent Less than 3 Months in the Activity

      Count of Individuals who have spent 3 to 6 Months in the Activity

      Count of Individuals who have spent  6 to 9 Months in the Activity

      Count of Individuals who have spent  9 to 12 Months in the Activity

      Count of Individuals who have spent  12 Months or Longer in the Activity

      Activity 1







      Activity 2







      Activity 3







      Activity 4







       

      Age Graph.png

       

      The activity durations are each unique and based on conditions:

      • ∙ Age of Activity 1 - If ABC = 100% and DEF <100%, then count days from ABC start to today
        • ∙ Count of Individuals in Activity 1 - Count if ABC = 100% and DEF <100%
      • ∙ Age of Activity 2- If ABC = 100% and GHI < 100%, then count days from ABC start to today
        • ∙ Count of Individuals in Activity 2- Count if ABC = 100% and GHI < 100%
      • ∙ Age of Activity 3 - If DEF = 100% and JKL <100%, then count days from DEF to today
        • ∙ Count of Individuals in Activity 3 - Count if DEF = 100% and JKL <100%
      • ∙ Age of Activity 4 - If JKL = 100% and MNO <100%, then count days from JKL to today
        • ∙ Count of Individuals in Activity 4 - If JKL = 100% and CFEC <100%