5 Replies Latest reply on Sep 4, 2018 1:11 AM by Ayush Rastogi

    Show percentage bars for pass fail records in database

    Ayush Rastogi

      I have created below Visualization, but I want to show data in percentage bars instead of pass fail count.

       

      ( Fail count / Sum of pass and fail ) * 100

       

      For example I want output as below, Please let me know what I need to do.

       

      A : 56%

      B: 0%

      C: 56%

      E: 0%

      F: 56%

      G: 56%

      H: 0%

      I: 56%

       

      Datasource structure is :

      Environment Name      Component      Status           Timestamp

      Test                               A                     PASSED      17/08/2018 11:34:28

      Test                               B                     PASSED      17/08/2018 11:34:29

      Test                               C                     PASSED      17/08/2018 11:34:30