Sub-query example

This example has been created to help walk through how sub-query works.

In the dashboard, we created 2 charts:

The first chart, ‘Employee Count by Job Role’ shows the number of employees in each job role:

The second chart, ‘Employee Count by Department’ shows the number of employees in each department:

We can now use the second chart, ‘Employee Count by Department’ to filter the first chart, ‘Employee Count by Department’.

If we use a ‘Like’ comparison operator, the first chart will be filtered to only show the employee numbers for the first department in the ‘Employee Count by Department’ chart - Human Resources (a data table has been created for comparison).

Chart Information, also confirms that ‘Employee Count by Job Role’ has been filtered on ‘Human Resources’.