This content has been marked as final. Show 3 replies
I am working with a dataset where the data follows a Hierarchy Logical flow (Test Project --> Test Plans --> Test Objectives --> Test Sessions). each one of the Hierarchy Levels listed below is represented by a table with foreign key to the upper level table.
Test Session will contain Test Cases and Test cases will have Test Runs. By Running a Test Case we obtain a Test Run. Test Runs Has Verdict (Pass, Fail, Blocke…) and it has Test Run Time.
Test case and Test Runs are stored in Separate table with proper keys.
Here is what I am trying to do.
I have created Drill-Down Group which Mimics the Hierarchy Logical flow (Test Project --> Test Plans --> Test Objectives --> Test Sessions) named "LogicalOrder"
I am trying to create bar chart to count the number of test cases with "LogicalOrder" as the first Dimension and last Verdict (from Test Runs) as second dimension where last will be decided by latest to run Test Run Verdict
How do I find last Run Verdict for each Test Case for the specific Group selected.