2 Replies Latest reply on Nov 27, 2018 1:28 AM by Amit Narkar

    Calculate Coverage

    Shreya Gupta

      Hi Team,

      Please help me in calculating the FR Coverage. Attached is the sample data screenshot for reference.

       

      As per the screenshot,

      Release Name, Work Request Number, System Name, BR ID, FR ID will be fetched from the database(SQL Server).

      Expected Count of BR ID, Expected Count of FR ID should be the calculated columns

      FR Coverage is the calculated column on the basis of below mentioned calculation:

       

      (Count of FR ID/Count of BR ID) * 100

       

      Please help me in getting the calculations(Expected Count of BR ID, Expected Count of FR ID,FR Coverage) in tableau. I am unable to write formulas for these calculations and derive the expected results.

       

      Seeking a quick response.

       

      Thanks