Forum Discussion

diogormendes's avatar
diogormendes
New Member
4 years ago

Connect Excel to Zephyr to retrieve data based on filter and create graphics

Is there a way to connect Excel to the Zephyr project whereas I can make formulas to be able to create filter?

Example: From all tests, I want the ones with COMPONENT "Layout" and Status "AUTOMATED" and then I can compare this to the same filter without automated and get the coverage for that specific filter ?

Reports
  • MisterB's avatar
    MisterB
    4 years ago

    Hi,

     

    There is the ability to return detailed test data in the Reports area of Zephyr Scale.  The data is generally the same for all reports that you run (try the Test Execution Results List report).  To access the data in Excel format, run the report, then in the top right-hand corner click on the button to export dataset to Excel.

     

    Does that work for you?

     

     

  • sonya_m's avatar
    sonya_m
    SmartBear Alumni (Retired)
    4 years ago

    Hi diogormendes !Looks like your post was on the Collaborator forum board, I moved it to Zephyr forums. Could you specify which Zephyr product you are using? Thank you

    • MisterB's avatar
      MisterB
      Champion Level 3
      4 years ago

      Hi,

       

      There is the ability to return detailed test data in the Reports area of Zephyr Scale.  The data is generally the same for all reports that you run (try the Test Execution Results List report).  To access the data in Excel format, run the report, then in the top right-hand corner click on the button to export dataset to Excel.

       

      Does that work for you?