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 department with the highest pay rate.
In this case, I want to look the department with the highest pay rate. Select Dimensions and go to Department. In Departments, select Top N. In Top N, enable this option and change the mode to Bottom. In count write down the number and in measure select Pay Rate.