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:




      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.