Forum Discussion

mike_lyons's avatar
mike_lyons
Occasional Contributor
11 years ago

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



4 Replies

  • mike_lyons's avatar
    mike_lyons
    Occasional Contributor
    Of course as soon as I post this one of my team members reported a bug on it.  If a test set has a last run status of incomplete it is not showing up on the bar chart correctly.  I will fix this and post a fix soon.
  • mike_lyons's avatar
    mike_lyons
    Occasional Contributor
    I updated the attachment with a new version that ignores test runs that are marked "incomplete".


  • so I changed the chart type directly in the database. 





    can you specify which table you were changing?

    i've been looking in DashBoardPageItems table, but i am not sure this is the right place to change chart types



    kr

    Ole



  • mike_lyons's avatar
    mike_lyons
    Occasional Contributor
    Ole,

      I am sure this answer is way to late to help you but maybe someone else can use the information.  The table I updated was  [SoftwarePlanner].[dbo].[GalleryItems].  I updated the column [GalleryItemType].



    Again, sorry for the reply so much later.  I am subscribed to this thread but never got an email saying it was updated.



    Good luck,

    Mike