6 Replies Latest reply on Dec 7, 2018 4:06 AM by Himanshu Goyal

    Need Pivot for the below data

    Rohit Pandey

      Good Afternoon ,

       

      Not able to get the exact count from the data-source .

       

      Requirement is that, Employee ID Column if value of Final status is Complete for both the task i.e. Onboarding and Induction under workflow column then status should be derived as Completed. , if any one workflow is missing then marked as pending otherwise marked  as failed.

       

              Sample Output excepted from the data-source

      Channel Employee_Status06-Dec
      HRCompleted5
      Pending4
      Failed5