How to integrate LEAPWORK Reporting with Tableau

LEAPWORK provides the reporting and dashboards experiences as an inbuilt property where user can visualize the different results of the test flow execution based upon the custom conditions defined as filter by and group by criteria.

Though some of the users heavily rely on third-party tools like Tableau for analytics purpose as a part of their existing frameworks and want to perform analytics around the automation flows executed in LEAPWORK through these tools itself.

LEAPWORK empowers its user to use its capabilities to integrate it with Tableau for more intuitive analytics for the automation test flows execution.

To do so, please follow the below steps:

1. Go to LEAPWORK Studio and navigate to the Reporting section.

2. Create your customized reports based upon the filter criteria and export them in to excel format by clicking on export as shown in the screenshot below:

3. After exporting the report into excel format, open the exported excel file and format it into a table as shown below:

4. After formatting of the table is been completed, Save the excel file

5. Open the Tableau desktop application, and import the excel from LEAPWORK by clicking on the Excel option as shown in the screenshot below:

6. After Tableau is connected successfully to the Excel Data source, the Excel sheet data will be visible in the tableau instance. To start the with the intuitive visualization, double click on the worksheet as highlighted in the screenshot below:

7. After the sheet is open the window will open, where intuitive analytics will be performed based upon the filter criteria in terms of rows and column by a drag and drop process. 

8. In Tableau the data from the source is presented in the form of dimensions(independent variables) and measures(variables dependent on the dimensions)as highlighted in the screenshot below:

Note: These dimensions and measures are automatically picked by Tableau based upon the columns and their values

9. User needs to select the dimension and measures in the form of columns and rows which acts as coordinates for the visual representation of the graph/charts. Also in tableau, based upon the dimension and corresponding measures used, it automatically picks and suggests the graph which best suites that the condition for the representation. 

A couple of example of the visual representations in the tableau is below:

10. In this way, LEAPWORK users can empower themselves to perform data analytics in a more intuitive form by creating different layouts based upon different filter criteria specific to Tableau as shown below:

For any clarification, please contact our Priority Support.