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’.

If an ‘In’ filter is used, multiple values from the ‘Employee Count by Department’ chart will be used.