When creating a dashboard item it is important to know what you want to display. We recommend having some questions in mind of what you want the dashboard to show before you start creating it.
The Dataset used in this dashboard is a sample of a Human Resources data. The Dataset contains information about Age, Gender, Marital Status, Name of the employee, Department, City, etc.
I would like to find out the following from the Dashboard:
For the example above I am going to show the Department.
Please seek assistance from your IT department as we do not provide SQL Query support.
If the value is already added in the binding menu, you don't need to add it in the Hidden Dimensions/Measures.
In this example, we want to filter the top 3 departments with the highest pay rate offered.
In this case, I want to look the top 3 departments with the highest pay rate offered. Select Dimensions and go to Departments. In Departments, select Top N. In Top N, enable this option and change the mode to Top. In count write down the number and in measure select Pay Rate.