3 Replies Latest reply: Oct 12, 2018 11:43 AM by Amit Gupta RSS

    How to count the same the same value in 3 different columns

    bhawna Agrawal

      Hi All,

       

      I have a sample table as shown below:

       

      UserLoginUsr_create_dateLDAP_StatusADStatusEmailStatus
      ABC10-Oct-2018PPP
      XYZ10-OCT-2018PNullP
      bbb10-Oct-18PPnull

       

      Above is a sample table where last 3 columns have status of these account creation marked with 'P' if success else null.

       

      I have a requirement to create a chart where need to display the total account created with total failed. Here I have 3 account per user and there respective status. As per the above example, I need output date wise no: of accounts created and failed. It means adding the total no of accounts created on 10th oct and total failed.

       

      Please suggest.

       

      Thanks in advance.