A better way to see test status
I am posting this solution here in hopes that it will help others. I am using the enterprise version of QA complete and I wanted a better dashboard to use for my Test Set status.
My goal was to create a report for the dashboard that shows a stacked bar chart for each test set. The stacked bar would show the latest test run status of each test in the test set for each configuration. So if I have a test set with 4 tests in it that is linked to 2 configurations the total for that stacked bar would be 8 (4 tests for each configuration). This includes counting tests that have never been run.
To try to recreate this solution, go into the setup tab and select the Report Setup/Manage Dashboard Charts from the left menu. I created a new chart with the information in the attached text document. I then added it to a dashboard via the Manage Dasboard pages menu.
One thing to note is the out of the box dashboard chart for test set status uses a horizontal bar chart but when you build your own you only have the option of a 3d vertical bar chart. I liked the horizontal version much better so I changed the chart type directly in the database. Not sure why they dont allow you to select the horizontal version but one simple update statement and I got what I wanted.
I also created 2 pie charts and attached that information as well. The first shows a pie chart of all the tests in the test sets for each configuration in the release by status, including ones that have not been run. The second pie chart shows a similar breakdown but at the test set level instead of the test set.
If you notice anything incorrect in the data displayed please let me know.
I hope this helps someone out there.
Good luck,
Mike
My goal was to create a report for the dashboard that shows a stacked bar chart for each test set. The stacked bar would show the latest test run status of each test in the test set for each configuration. So if I have a test set with 4 tests in it that is linked to 2 configurations the total for that stacked bar would be 8 (4 tests for each configuration). This includes counting tests that have never been run.
To try to recreate this solution, go into the setup tab and select the Report Setup/Manage Dashboard Charts from the left menu. I created a new chart with the information in the attached text document. I then added it to a dashboard via the Manage Dasboard pages menu.
One thing to note is the out of the box dashboard chart for test set status uses a horizontal bar chart but when you build your own you only have the option of a 3d vertical bar chart. I liked the horizontal version much better so I changed the chart type directly in the database. Not sure why they dont allow you to select the horizontal version but one simple update statement and I got what I wanted.
I also created 2 pie charts and attached that information as well. The first shows a pie chart of all the tests in the test sets for each configuration in the release by status, including ones that have not been run. The second pie chart shows a similar breakdown but at the test set level instead of the test set.
If you notice anything incorrect in the data displayed please let me know.
I hope this helps someone out there.
Good luck,
Mike
