9 Replies Latest reply: Feb 3, 2016 5:17 AM by Sunny Talwar RSS

    Calculative dimensions

    Priyanka Pandey

      Hi All,

      I have a excel data source containing data in below format.

         

      Job IDJob TypeJob Start DateEnd Date Status
      1A23-01-1601-02-16Started
      2B25-01-1601-02-16Ended
      3B28-01-1601-02-16Paused
      4A01-02-1601-02-16Suspended
      5C23-01-1601-02-16Started
      6D30-01-1601-02-16Ended
      7M21-01-1601-02-16Paused
      8W01-02-1601-02-16Suspended
      9W01-02-1601-02-16Started
      10A24-01-1601-02-16Ended
      11A25-01-1601-02-16Paused
      12B26-01-1601-02-16Suspended
      13D30-01-1601-02-16Paused
      14C31-01-1601-02-16Suspended

       

      Output required is

       

      Job TypeCountDay1Day2Day3Day4Day5>Day5
      A4100003
      B3000 12
      C2010001
      D2003000
      M2000001
      W2200000

       

       

      Calculation of Day1,Day2...>Day5 is as follows

      i will get ageing with the help of this formula = Today()- Job Start Date, Now if difference is 1 then it should be displayed under

      "Day 1"column similarly if difference is 2 it should be displayed under "Day 2" and so on.

      Count is count of Job ID

      Please help me out int getting desired output.

       

      Thanks in advance

      -Priyanka